Query schedules

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.

IMPORTANT

The following is a list of limitations for scheduled queries when using the Query Editor. They do not apply to the Query Service API:
You can only add a schedule to a query that has already been created, saved, and run.
You cannot add a schedule to a parameterized query.
Scheduled queries cannot contain an anonymous block.

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.

Create a query schedules

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 Query Editor with the Schedules tab highlighted.

The schedules workspace appears. Select Add Schedule to create a schedule.

The Query Editor Schedule workspace with Add schedule highlighted.

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.

The Schedule details panel highlighted.

You can choose the following options for Frequency:

  • Hourly: The scheduled query will run every hour for the date period you selected.
  • Daily: The scheduled query will run every X days at the time and the date period you selected. Please note that the time selected is in UTC, and not your local time zone.
  • Weekly: The selected query will run on the days of the week, time, and the date period you selected. Please note that the time selected is in UTC, and not your local time zone.
  • Monthly: The selected query will run every month at the day, time, and the date period you selected. Please note that the time selected is in UTC, and not your local time zone.
  • Yearly: The selected query will run every year at the day, month, time, and the date period you selected. Please note that the time selected is in UTC, and not your local time zone.

For the output dataset, you have the option to use either an existing dataset or create a new dataset.

IMPORTANT

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.

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.

The schedules workspace with the newly created schedule highlighted.

Delete or disable a schedule

You can delete or disable a schedule from the schedules workspace. You must select a query template from either the Templates tab or the Scheduled Queries tab to navigate to the Query Editor and select Schedule 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.

IMPORTANT

You must disable the schedule before you can delete a schedule for a query.

Select Delete a schedule to delete the disabled schedule.

The schedules workspace with Disable schedule and Delete schedule highlighted.

On this page