Error in Google Play transfer frequency - Google BigQuery

2
votes

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?

1
google-cloud-platformgoogle-bigquerygoogle-play
Hello, the workaround proposed by Ilya Berdichevsky should do the job. To me this looks like an issue related to the web-UI so in case the problem persists I suggest to open a ticket with GCP Technical Support or to open a Public Issue Tracker - Juan Fernández Afonso
Thank you for your advice. So true. If it doesn't work, I'll contact with Google Cloud Support. Tank you. - aberlour

1 Answers

1
votes

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.