I need a scheduled query only between Monday to Friday between 9 and 7 o'clock:
Scheduled queries is currently: every hour from 9:00 to 19:00
But how to modify for Mo-Fr ?
Thanks
UPDATE: The question at hand is much more complex than the Custom setting in BigQuery Scheduled Queries allows. For this purpose, @guillaume blaquiere has the best suggestion: use Cloud Scheduler to run a cron job. Tools like Crontab Guru can be helpful in creating a statement such as 00 9-19 * * 1-5.
For simpler Scheduled Queries, please review the following from the official documentation: Set up scheduled queries.
Specifically,
To specify a custom frequency, select Custom, then enter a Cron-like time specification in the Custom schedule field; for example every 3 hours.
There is excellent documentation in the Custom Interval tab here on the many options you have available in this field.
