Some cloud data warehouses (CDW) have a query results cache that Sigma can use to retrieve query results without incurring additional compute costs. This leads to better performance.

Sigma workbooks have a cache duration setting, or time to live (TTL). The result is cached in the data warehouse, not in Sigma. The cache is in the form of a copy of results and is stored for 24 hours. If the source data changes, the cached results will reflect irrelevant/inaccurate data. If u attempt to return the result of a query, you can use this setting to specify that the result cache is xx minutes old.

The default duration is 10 minutes. 

Summary of Content

Requirements
Set a Cache Duration
Related Resources

Requirements

  • This feature is only available for CDWs that support result caches. 
  • To set a workbooks' cache duration, you must be an organization Admin.

Set a Cache Duration

  1. Click the caret (▼) button to the right of the refresh button in your workbook's header.

  2. Select Data refresh.
    Screen_Shot_2022-02-02_at_11.57.27_AM.png
    This will open the Data Refresh Settings modal.

  3. Under Cache duration set a minute or hour duration.
    Screen_Shot_2022-01-31_at_1.41.56_PM.png
  4. Click Save.

Related Resources

Workbook Refresh Options