Query caching and scheduled queries

How to control when your queries run.

Enable caching in your workspace
Caching must first be enabled in your workspace settings.
Query caching is only available on paid plans.
Set your canvas caching settings
In the top right of the canvas you'll notice a play button. Clicking it will open the option to Refresh all results or view Caching settings. 
Access query execution settings from the icon in the canvas navigation bar
Caching settings
In the caching settings menu, you'll see three options for your caching your queries: 
Live Data
With this setting, whenever your canvas or report is opened, the queries in any visible frames will be sent to the database, ensuring the most up-to-date data possible. 
Static
With this setting, queries will not run unless edited or forced to re-run. This is the least 'fresh' option of all, but the most appealing if you want very query queries to run on your database. 
Scheduled
The best of both worlds. 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. 
​

Querying data - Previous

Local DuckDB cells

Next - Querying data

Focus mode (beta)

Last modified 18d ago