Google Big Query won't let me schedule query

user_10862360 0
Viewed 177

I am an owner of the Google Big Query project and I am trying to setup a schedule query. But it throws me an error as shown on image:

Error

I have investigated across StackOverflow but nothing works for me. I have tried:

  1. Run query first before creating schedule query
  2. Choose data location (in my case EU)
  3. Verify access permission - I am owner of the project.

Can anyone help me please?

firebase-analytics google-bigquery
1 Answers

You will get this Schedule Query Error message because of the following reasons:

  • If you selected a wrong Dataset location in the New scheduled query will throw an error message “Scheduled Query Error”.

  • The least possible limit for the scheduled query under custom is 15 minutes. So, if you try scheduling a query by setting a custom time less than every 15 minutes will throw an error message 'Scheduled Query Error'. Refer to this doc for more information.

  • If your Cron-like time specification syntax is not valid in the Custom schedule field will throw an error message 'Scheduled Query Error'. Refer to this doc for valid formats.

user_157471060
Related