Skip to main content
Query Scheduling allows you to schedule a query to run at a specific time and frequency. Queries on Dune usually execute when a user triggers an automatic or interactive execution. This means that if you have a dashboard that is not frequently viewed, the data displayed on the dashboard may be outdated and execution of the queries will only be triggered once a user views the dashboard. Especially for dashboards that contain resource-intensive queries, this can lead to long loading times for the viewer. To keep your dashboard up-to-date and to ensure that your queries are executed reliably and in a timely manner, you can schedule them to run at a specific time and frequency. Scheduled queries can be run on medium and large query engines, which will require credits. Credits are consumed based on actual compute resources used for each scheduled query execution.

​
How to Schedule a Query

  1. Start by clicking the scheduler (clock) icon located at the bottom of the query editor, to the left of the “Run” button
  2. A dialog will prompt you to set a refresh schedule and an execution tier. Please note that scheduled queries can only be run on medium and large query engines, which will require credits.
  3. The dialog will display an estimated monthly credit consumption for this query scheduling, along with a monthly quota. These values will adjust based on the frequency and execution tier you select.
  4. Save the schedule
  5. Your query will execute once to start the schedule, and then will execute according to the schedule you set.

​
Query Scheduling Limitations

  • Query scheduling is currently not available for queries with parameters.
  • The query schedule is removed when the queries are archived or when the ownership changes (e.g., when a query is migrated).
  • There are no notifications available for scheduled query failures as of now. Failed scheduled executions follow the same billing rules as other executions: SQL syntax/semantic errors, internal query-engine failures, and query-engine capacity-limit failures are not charged; timeouts or cancellations after compute was used may consume credits.

​
Adjusting or Cancelling a Query Schedule

To modify or cancel a query schedule, click the scheduler (clock) icon again to reopen the scheduling dialog. From there you can adjust the frequency, time, or execution tier. To stop the schedule entirely, scroll to the bottom of the dialog and click the Stop button.

​
Scheduling entire dashboards

Instead of scheduling individual queries, you can also schedule entire dashboards. Learn more about scheduling dashboards here.