Dashboard Cache
Dashboard caching helps improve query performance by storing the results of your dashboard queries. This feature is particularly useful for dashboards with complex queries or large datasets.
note
For OSS version, dashboard caching is disabled for DuckDB data sources (including sample datasets). This feature is available for all other data sources.
Enabling Dashboard Cache
To enable dashboard caching:
- Click the more icon (⋮) in the top-right corner of your dashboard
- Select "Cache Settings" from the dropdown menu
- In the cache settings drawer, toggle the "Enable Cache" option
- Configure your preferred refresh schedule:
- Daily
- Weekly
- Custom schedule
- Manual refresh only
Manual Cache Refresh
You can refresh the cache manually in two ways:
For Individual Charts
- Click the more icon (⋮) in the top-right corner of the chart
- Select "Refresh Cache" from the dropdown menu
For Entire Dashboard
- Click the more icon (⋮) in the top-right corner of the dashboard
- Select "Refresh All Caches" from the dropdown menu
Monitoring Cache Status
To check if a chart is using cached data and when it was last refreshed:
- Look at the bottom of each chart
- The "Last Refreshed" timestamp indicates:
- The chart is using cached data
- When the data was last cached