Scheduling a query with custom times

Question

I am trying to schedule a query in BigQuery so that it runs each day, every 30 minutes running between the hours of 7:00 am and 11:30 am.

I believed the following should work in the custom schedule field:

every 30 minutes between 7:00 and 11:30

When I try this, the following error is displayed:

Error creating scheduled query: The specified schedule is invalid: [every 30 minutes between 7:00 and 11:30]

I can schedule it to run every 30 minutes with no issue, but this will run the query many more times each day than is necessary.

Answer 1

I think you are having an error because you are using between - and instead of from - to.

I have found and example:

every 5 minutes from 10:00 to 14:00

So, I tried with: every 30 minutes from 07:00 to 11:30, and worked as expected.