A Snowflake query took 40 minutes to run. The results indicate that ‘Bytes spilled to local storage’ was a large number.
What is the issue and how can it be resolved?
A Snowflake query took 40 minutes to run. The results indicate that ‘Bytes spilled to local storage’ was a large number.
What is the issue and how can it be resolved?
The warehouse is too small to handle the query efficiently, resulting in a large amount of 'Bytes spilled to local storage'. Increasing the size of the warehouse will provide more resources to keep data in memory, thus reducing or eliminating the need to spill data to local storage.
Answer is B. warehouse size should be increased. multi cluster warehouse will just help in increasing paralelism.
B is correct https://github.com/dbt-labs/docs.getdbt.com/discussions/1550 When you have spillage, increasing warehouse size almost always helps.
The correct answer is B.
B is correct
https://docs.snowflake.com/en/user-guide/performance-query-warehouse-memory#:~:text=When%20memory%20spillage,causing%20the%20spillage.
The answer should be B since this needs to be solved by scale up, not scale out.
Answer is D