Customize table settings for scheduled queries
You can adjust the columns on the Scheduled Queries tab to your needs. To open the Customize table settings dialog and edit available columns, select the settings icon (
Toggle the relevant checkboxes to remove or add a table column. Next, select Apply to confirm your choices.
Manage scheduled queries with inline actions
The Scheduled Queries view offers various inline actions to manage all of your scheduled queries from one location. Inline actions are indicated in each row with ellipsis. Select the ellipsis of a scheduled query that you want to manage to see the available options in a pop-up menu. The available options include Disable schedule or Enable schedule, Delete schedule, Subscribe to query alerts, and Enable or Disable quarantine.
Disable or enable a scheduled query
To disable a scheduled query, select the ellipsis for the scheduled query you want to manage, then select Disable schedule from the options in the pop-up menu. A dialog appears to confirm your action. Select Disable to confirm your setting.
Once a scheduled query is disabled, you can enable the schedule through the same process. Select the ellipsis, then select Enable schedule from the available options.
Delete a scheduled query
To delete a scheduled query, select the ellipsis for the scheduled query you want to manage, then select Delete schedule from the options in the pop-up menu. A dialog appears to confirm your action. Select Delete to confirm your setting.
Once a scheduled query is deleted, it is not removed from the list of scheduled queries. The inline actions provided by the ellipses are removed and replaced by the grayed out add alert subscription icon. You cannot subscribe to alerts for the deleted schedule. The row remains in the UI to provide information on runs conducted as part of the scheduled query.
If you want to schedule runs for that query template, select the template name from the appropriate row to navigate to the Query Editor, then follow the instructions to add a schedule to a query as described in the documentation.
Subscribe to alerts
To subscribe to alerts for scheduled query runs, select either the ...
(ellipsis) or alert subscription icon (
The Alerts dialog opens. The Alerts dialog subscribes you to both UI notifications and email alerts. There are several alert subscription options available: start
, success
, failure
, quarantine
, and delay
. Check the appropriate box or boxes and select Save to subscribe.
The table below explains the supported query alert types:
Alert type | Description |
---|---|
start | This alert notifies you when a scheduled query run is initiated or starts to process. |
success | This alert informs you when a scheduled query run completes successfully, indicating that the query executed without any errors. |
failed | This alert triggers when a scheduled query run encounters an error or fails to execute successfully. It helps you identify and address issues promptly. |
quarantine | This alert is activated when a scheduled query run is put into a quarantined state. When queries are enrolled in the quarantine feature, any scheduled query that fails ten consecutive runs is automatically put into a Quarantined state. They then require your intervention before any further executions can take place. |
delay | This alert notifies you if there is a delay in the outcome of a query execution beyond a specified threshold. You can set a custom time that trigger the alert when the query runs for that duration without either completing or failing. |
See the alert subscriptions API documentation for more information.
View the query details
Select the information icon (
Quarantined queries
When enrolled in the quarantine feature, any scheduled query that fails ten consecutive runs is automatically put into a Quarantined status. A query with this status becomes inactive and does not execute at its scheduled cadence. It then requires your intervention before any further executions can take place. This safeguards system resources as you must review and correct the issues with your SQL before further executions occur.
To enable a scheduled query for the quarantine feature, select the ellipses (...
) followed by Enable quarantine from the dropdown menu that appears.
Queries can also be enrolled in the quarantine feature during the schedule creation process. See the query schedules documentation for more information.
Query run delay
Stay in control of your compute hours by setting alerts for query delays. You can monitor query performance and receive notifications if a query’s status remains unchanged after a specific period. Use the ‘Query Run Delay’ alert to be notified if a query continues to process after a specific period of time without completing.
When you subscribe to alerts for scheduled query runs, one of the available alerts is the Query Run Delay. This alert requires you to set a threshold for the time spent executing, at which point you are notified of the delay in processing.
To choose a threshold duration that triggers the notification, either enter a number in the text input field or use the up and down arrows to increase in increments of one minute. Since the threshold is set in minutes, the maximum duration for observing a query run delay is 1440 minutes (24 hours). The default time period for a run delay is 150 minutes.
See the subscribe to alerts section to learn how to subscribe to Query Run Delay alerts.
Filter queries
You can filter queries based on run frequency. From the Scheduled Queries tab, select the filter icon (
To filter the list of queries based on their run frequency, select either the Scheduled or Run once filter checkboxes.
Once you have enabled your filter criteria, select Hide Filters to close the filter panel.
Query runs schedule details
To open the schedule details page, select a query name from the Scheduled Queries tab. This view provides a list of all the runs executed as part of that scheduled query. The information provided includes the start and end time, status, and dataset used.
This information is provided in a five-column table. Each row denotes a query execution.
Column name | Description |
---|---|
Query run ID | The query run ID for the daily execution. Select the Query run ID to navigate to the Query run overview. |
Query run start | The timestamp when the query was executed. The timestamp is in UTC format. |
Query run complete | The timestamp when the query was completed. The timestamp is in UTC format. |
Status | The status of the most recent query execution. The status values are: Success , Failed , In progress , or Quarantined . |
Dataset | The dataset involved in the execution. |
Details of the query being scheduled can be seen in the Properties panel. This panel includes the initial query ID, client type, template name, query SQL, and cadence of the schedule.
Select a query run ID to navigate to the run details page and view query information.