CODEWITHSUNDEEP
google-cloud-platformgoogle-bigquerygoogle-play
aberlour
aberlour

Reputation: 23

Error in Google Play transfer frequency - Google BigQuery

I want to set weekly Google Play transfer, but it can not be saved. At first, I set daily a play-transfer job. It worked. I tried to change transfer frequency to weekly - every Monday 7:30 - got an error:

"This transfer config could not be saved. Please try again. Invalid schedule [every mon 7:30]. Schedule has to be consistent with CustomScheduleGranularity [daily: true ].

I think this document shows it can change transfer frequency: https://cloud.google.com/bigquery-transfer/docs/play-transfer

Can Google Play transfer be set to weekly?

Upvotes: 2

Views: 339

Answers (1)

Ilya Berdichevsky
Ilya Berdichevsky

Reputation: 1288

By default transfer is created as daily. From the same docs:

Daily, at the time the transfer is first created (default)

Try to create brand new weekly transfer. If it works, I would think it is a web UI bug. Here are two other options to change your existing transfer:

  1. BigQuery command-line tool: bq update --transfer_config Very limited number of options are available, and schedule is not available for update.
  2. BigQuery Data Transfer API: transferConfigs.patch Most transfer options are updatable. Easy way to try it is with API Explorer. Details on transferconfig object. schedule field need to be defined:

Data transfer schedule. If the data source does not support a custom schedule, this should be empty. If it is empty, the default value for the data source will be used. The specified times are in UTC. Examples of valid format: 1st,3rd monday of month 15:30, every wed,fri of jan,jun 13:15, and first sunday of quarter 00:00. See more explanation about the format here: https://cloud.google.com/appengine/docs/flexible/python/scheduling-jobs-with-cron-yaml#the_schedule_format NOTE: the granularity should be at least 8 hours, or less frequent.

Upvotes: 1

Related Questions