A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.
What will occur?
A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.
What will occur?
When a query is executed in Snowflake and the data has not changed, the system can fetch the results from the result cache. This is because Snowflake's architecture includes a results cache that stores the results of all queries executed within the past 24 hours. Since the data did not change between the two queries and only 4 hours elapsed, the result will be retrieved from the result cache. No virtual warehouse will be used during this process.
A is right. Don't overthink it
seems i am already overthinking - why A? if another user is from diff account then how the results can be retrieved from result cache ?, Thanks
A. No virtual warehouse will be used, data will be read from the result cache.
Correct
For sure