Set a Cache Duration
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 default duration is 10 minutes.
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 or inaccurate data.
If you attempt to return the result of a query, you can use the Cache duration setting to specify that the result cache is a certain number of minutes old.
Contents
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
-
Click the caret (▼) button to the right of the refresh button in your workbook's header.
-
Select Data refresh.
The Data Refresh Settings modal opens. - Under Cache duration set a minute or hour duration.
- Click Save.