A Data Engineer has created a dashboard that sends the identical SQL SELECT clause to Snowflake every 12 hours.
SELECT
For how long will Snowflake use the persisted query results in the result cache, assuming that the underlying data remains unchanged?
Snowflake resets a persisted query result’s 24-hour retention period whenever the result is reused. Because the identical query runs every 12 hours and the underlying data has not changed, the cached result can continue to be reused until the maximum retention limit of 31 days from the original execution; it is then purged.
Community Discussion