Query caching and scheduled queries
How to control when your queries run.

In the top right of the canvas you'll notice a play button. Clicking it will open the option to Re-run all cells or open caching settings.

In the caching settings menu, you'll see three options for your caching your queries:

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.
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.
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.
Last modified 4mo ago