A Data Engineer has developed a dashboard that will issue the same SQL select clause to Snowflake every 12 hours.
How long will Snowflake use the persisted query results from the result cache, provided that the underlying data has not changed?
A Data Engineer has developed a dashboard that will issue the same SQL select clause to Snowflake every 12 hours.
How long will Snowflake use the persisted query results from the result cache, provided that the underlying data has not changed?
Snowflake's result cache can persist query results for up to 31 days, provided the underlying data has not changed and the query is executed again within 24 hours. Each execution within this period resets the 24-hour retention period for the result, maintaining it in the cache for up to 31 days from the initial execution.
Each time the persisted result for a query is reused, Snowflake resets the 24-hour retention period for the result, up to a maximum of 31 days from the date and time that the query was first executed. After 31 days, the result is purged and the next time the query is submitted, a new result is generated and persisted. https://docs.snowflake.com/en/user-guide/querying-persisted-results
correct ans is D 31 days because it can extends upto 31 days if executed again within 24 hours.
Each time the persisted result for a query is reused, Snowflake resets the 24-hour retention period for the result, up to a maximum of 31 days