SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ72

VerifiedDesign and Manage Snowflake Resources and Performance

A Data Engineer has created a dashboard that sends the identical SQL SELECT clause to Snowflake every 12 hours.

For how long will Snowflake use the persisted query results in the result cache, assuming that the underlying data remains unchanged?

Explanation

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.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!