Query caching and scheduling
How to control when your queries run.
Last updated
How to control when your queries run.
Last updated
Caching must first be enabled in your workspace settings.
Query caching is only available on paid plans.
In the right sidebar, when no objects are selected the current caching settings for the canvas are displayed. To update these settings, click the Change button.
These settings are only accessible by analysts and above.
In the caching settings menu, there are three options for caching query results:
Never cache results
With this setting, whenever your canvas or report is opened, the queries for any visible cells will be sent to your database, ensuring the most up-to-date data possible. This option will result in the largest load on your database.
With this setting, query results are saved for the specified duration. If the same query is run repeatedly within that time window, then cached results are returned. This option is often a reasonable trade-off between improving result freshness while reducing load on your database.
If cells are edited or executed using the Run cell button, then queries are always re-run.
With this setting, queries will not run unless cells are edited or executed using the Run cell button. This option minimises database load, but may result in old data being displayed.
For canvases that indefinitely cache their results, each time a version of the canvas is created, a snapshot of the current query results is saved, allowing you to browse historical data
With this setting you can set when you want the queries to refresh in your canvas or report. Once they have been updated, they won't run again unless edited, forced to re-run, or until the next scheduled update time.
