QuestionQ25

Performance Optimization, Querying & Transformation

A user executes a query against a large table on a Medium virtual warehouse. A different user runs that same query on the same table by using another warehouse.

Which caches will be used?

Explanation

Snowflake’s warehouse data cache is local to a running warehouse, so a query issued on a different warehouse cannot use the first warehouse’s cached table data. Persisted query results are independent of warehouse and can be reused when the query matches and the underlying data and result-reuse conditions have not changed; metadata caching also remains available. Therefore, the applicable caches are the metadata cache and query result cache.

Learn more

Community Discussion

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