Refreshing SQL Dashboard
You can schedule the dashboard to automatically refresh at an interval.
- At the top of the page, click Schedule.
- If the dashboard already has a schedule, you see Scheduled instead of Schedule.
- Select an interval, such as Every 1 hour.
- You can click Advanced to create a more complex interval, such as every 5 years.
- Select a SQL warehouse. A SQL warehouse is a compute resource that is specific to Databricks SQL. The SQL warehouse runs the dashboard’s queries and generates the visualizations when the dashboard is refreshed.
- Admin users can create, configure, and delete SQL warehouses.
- Optionally, subscribe workspace users or notification destinations to receive an email version of the dashboard when it is automatically refreshed.
- Admin users can create, configure, and delete notification destinations. The email addresses of workspace users are automatically added as notification destinations.
- Click Save.
- The dashboard will be refreshed according to the schedule.
- To stop automatically refreshing a dashboard:
- Click Scheduled.
- Set Refresh to Never.
- Click Save.