You can automate query runs by creating query schedules. Scheduled queries run on a custom cadence to manage your data based on frequency, date, and time. You can also choose an output dataset for your results if required. Queries that have been saved as a template can be scheduled from the Query Editor.
You can only add a schedule to a query that has already been created, saved, and run.
Any scheduled queries are added to the list in the Scheduled queries tab. From that workspace you can monitor the status of all scheduled query jobs through the UI. On the Scheduled queries tab you can find important information about your query runs and subscribe to alerts. The available information includes the status, schedule details, and error messages/codes should a run fail. See the Monitor scheduled queries document for more information.
To add a schedule to a query, select a query template from either the Templates tab or the Scheduled Queries tab to navigate to the Query Editor.
To learn how to add schedules using the API, please read the scheduled queries endpoint guide.
When a saved query is accessed from the Query Editor, The Schedules tab appears below the query name. Select Schedules.
The schedules workspace appears. Select Add Schedule to create a schedule.
The schedule details page appears. On this page, you can choose the frequency of the scheduled query, the start and end date, the day of the week the scheduled query will run, as well as what dataset to export the query to.
You can choose the following options for Frequency:
For the output dataset, you have the option to use either an existing dataset or create a new dataset.
Since you are using either an existing or creating a new dataset, you do not need to include either
INSERT INTO or
CREATE TABLE AS SELECT as part of the query, since the datasets are already set. Including either
INSERT INTO or
CREATE TABLE AS SELECT as part of your scheduled queries will result in an error.
If you do not have access to parameterized queries, continue on to the delete or disable a schedule section.
The parameterized query UI feature is currently available in a limited release only and is not available to all customers.
If you are creating a scheduled query for a parameterized query, you must now set the parameter values for these query runs.
After confirming all these details, select Save to create a schedule. You are returned to the schedules workspace that displays details of the newly created schedule, including the schedule ID, the schedule itself, and the schedule’s output dataset. You can use the schedule ID to look up more information about the runs of the scheduled query itself. To learn more, please read the scheduled query run endpoints guide.
You can delete or disable a schedule from the schedules workspace of a particular query or from the Scheduled Queries workspace that lists all the scheduled queries.
To access the Schedules tab of your chosen query, you must select the name of a query template from either the Templates tab or the Scheduled Queries tab. This navigates to the Query Editor for that query. Form the Query Editor, select Schedules to access the schedules workspace.
Select a schedule from the rows of available schedules. You can use the toggle to disable or enable the scheduled query.
You must disable the schedule before you can delete a schedule for a query.
Select Delete a schedule to delete the disabled schedule.
Alternatively, the Scheduled Queries tab offers a collection of inline actions for each scheduled query. The available inline actions include Disable schedule or Enable schedule, Delete schedule, and Subscribe to alerts for the scheduled query. For complete instructions on how to delete or disable a scheduled query through the scheduled Queries tab, please see the monitor scheduled queried guide.