Set a query ID cache duration
Some cloud data warehouses or data platforms have a query results cache that Sigma can use to retrieve query results without incurring additional compute costs. When available from the CDW, Sigma uses a query ID to access the cached data, which leads to better performance when compared to performing a new query to retrieve the data.
Each workbook has a query ID cache duration setting, or time-to-live (TTL). The default query ID cache duration is 10 minutes.
If the source data changes during the cache duration, the cached results reflect irrelevant or inaccurate data. If a query ID exceeds the cache duration setting, a new query is performed to retrieve the most accurate results. For more detailed information, see Caching and data freshness.
The actual query results are cached in the data platform, not in Sigma. Typically, the cache is in the form of a copy of results and is stored for 24 hours.
If you attempt to return the result of a query, you can use the Cache duration setting to specify that the results cache is a certain number of minutes old.
Requirements
- This feature is only available for data platforms that support query result caches that Sigma can access using an ID, such as Snowflake and BigQuery.
- To set a the query ID cache duration for a workbook, you must be assigned the Admin account type.
Set a query cache ID duration
To change the default cache duration for retrieving cached results from the data platform, do the following:
-
In a workbook, click the down arrow (
) next to the refresh button (
) .
-
In the menu, select Data refresh.
The Data Refresh Settings modal opens.
-
For Cache duration, set a duration in either minutes or hours.
-
Click Save.
Updated 1 day ago