A Data Engineer runs a complex query and wants to use Snowflake’s query-results caching capability to reuse its results.
Which conditions must be satisfied?
Snowflake can reuse a persisted query result only when the new query exactly matches the prior query, the contributing table data/structure has not changed, and the table’s micro-partitions have not changed because of changes to other data in that table. Result reuse is enabled by default through the USE_CACHED_RESULT session parameter and does not require the same virtual warehouse.
USE_CACHED_RESULT
Community Discussion