Count
count.co
  • Getting Started
    • What is Count?
    • Count FAQ
    • Intro to your workspace
    • Example canvases
    • Getting started guides
      • Set up your workspace and projects
        • 1. Review workspace settings
        • 2. Create and organise your projects
      • Canvas orientation
      • Your first ad hoc analysis
        • 1. Examples and templates
        • 2. Build your first queries
        • 3. Create visuals
        • 4. Caching, local cells and scheduling
        • 5. Collaborating with a stakeholder
      • Your first report
        • 1. Examples and templates
        • 2. Filters and control cells
        • 3. Sharing your report
        • 4. Alerts
  • Connect your data
    • Database connection overview
      • Athena
      • Azure Synapse
      • BigQuery
      • Databricks
      • Microsoft SQL Server
      • MySQL
      • PostgreSQL
      • Redshift
      • Snowflake
    • Refresh database schema
    • Upload CSV files
    • dbt integration
      • ☁️dbt Cloud integration
      • 👩‍💻dbt Core integration
  • Import & Export
    • Import from other tools
      • Import Miro files
      • Import SQL files
      • Import Google Sheets
      • Import Jupyter notebooks
    • Export code and results
      • Export compiled SQL and Jinja-SQL
      • Export CSV files
      • Export images and PDF files
  • THE CANVAS
    • Navigating the canvas
      • Canvas tool bar
      • Data sidebar
      • Customizing the canvas
    • Canvas objects
      • Cells
      • Text and markdown
      • Shapes and tools
      • Sticky notes
      • Frames
      • Images
      • Embeds
      • Stamps
      • Grouping objects
      • Object order and alignment
      • Locking objects
      • Scaling objects
      • Shared styles
    • Overviews
    • Templates
    • Count AI
    • Alerts and subscriptions
      • Slack integration
    • Keyboard shortcuts
  • Querying data
    • Cells overview
      • Dynamic query compilation engine
    • SQL cells
      • Referencing other cells
      • Jinja templating
      • SQL formatting
    • Python cells
    • Visual and low-code cells
      • Calculations in visuals and low-code cells
      • Joins in visuals and low-code cells
    • Control cells
      • Single and multiple selects
      • Date controls
      • Text, number, and boolean controls
      • Custom control cells
    • Local DuckDB cells
      • DuckDB on the server
    • Query caching and scheduling
    • Manage queries and results
    • Troubleshooting
  • Visualizing data
    • Visualization overview
    • Templated visuals
    • Custom visuals
      • Marks
      • Facet
      • Subplots
      • Style
      • Filters
    • Formatting a visual
      • Axes
        • Secondary Axis
      • Colors and labels
      • Legends
      • Tooltips
    • Column summaries
    • Dynamic text
    • Every Visual Under the Sun
  • Presenting and Reporting
    • Reports and Slides
  • Count Metrics
    • Intro to Count Metrics
    • Build and edit a catalog
    • Views
      • Creating views
      • Customizing views
    • Datasets
      • Creating datasets
    • Save changes to the catalog
      • Catalog validation
      • Version control
    • Exposing catalogs to the workspace
    • Caching in Count Metrics
    • Using the catalog
      • Explore from cell
  • Sharing and Permissions
    • Real-time collaboration
    • Comments
    • Sharing permissions
    • Shared links
    • Embedding canvases
  • History and Versions
    • Version control
    • Duplicating and merging
    • Data snapshots
  • Settings and administration
    • Workspace settings
      • Workspace members
      • Groups
      • Tags
      • Billing
      • Single sign-on (SSO)
        • Okta
        • Entra ID
        • JumpCloud
        • Google
        • Generic OIDC
      • Brand
    • Connection settings
    • Project settings
    • User settings
    • Roles and permissions
  • Quick guides
    • Interactive control guides
      • Date ranges
      • Date groupings
      • Search
      • Select All
  • Resources
    • Join the Slack community
  • Blog
  • Security overview
  • Terms of use
  • Pricing FAQ
Powered by GitBook
On this page
  • Enable caching in your workspace
  • View canvas caching settings
  • Caching settings
  • Scheduling settings
  1. Querying data

Query caching and scheduling

How to control when your queries run.

PreviousDuckDB on the serverNextManage queries and results

Last updated 1 month ago

Enable caching in your workspace

Caching must first be enabled in your :

View canvas caching settings

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.

Caching settings

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.

Cache results for...

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.

Cache results indefinitely

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.

Scheduling settings

If a schedule is selected, Count will execute the cells in this canvas that are connected to databases periodically. These scheduled queries are always run, even if cached results are available, and the new results will update those in the cache.

For example, to schedule a run at 8AM on weekdays only, enter 0 8 * * 1-5 . Note that cron custom expressions are always based on the UTC timezone.

Query result caching is only available on .

These settings are only accessible by and above.

By default all canvas cells are executed, but it is possible to execute fewer cells by hiding or cells, and choosing the appropriate option.

Several simple schedules can be selected from the options here. For more custom schedules, choose the Custom option to enter a schedule in the form of a .

paid plans
analysts
cron expression
For workspaces where caching is enabled, the default cache duration for new canvases can also be set
The Caching settings menu.
The scheduling settings.
workspace settings
disabling