Answer-first summary for fast verification
Answer: The warehouse is too small. Increase the size of the warehouse to reduce the spillage.
The query shows high 'Bytes spilled to local storage', which indicates memory spillage occurs when a warehouse lacks sufficient memory to process operations in RAM, forcing data to spill to local disk. This significantly slows query performance. Option B is correct because increasing warehouse size provides more memory per cluster, directly addressing the memory constraint causing spillage. Option D is incorrect as multi-cluster warehouses increase parallelism but do not increase memory per cluster, so spillage would persist. Option A is incorrect because a larger warehouse would exacerbate, not reduce, spillage. Option C is incorrect as console timeouts are unrelated to spillage. The community discussion strongly supports B with 100% consensus and upvoted comments emphasizing that scaling up (increasing warehouse size) resolves spillage, while scaling out (multi-cluster) does not.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A query in Snowflake executed for 40 minutes, and the profile output shows a high value for 'Bytes spilled to local storage'. What is the root cause of this performance issue, and what are the recommended steps to resolve it?
A
The warehouse is too large. Decrease the size of the warehouse to reduce the spillage.
B
The warehouse is too small. Increase the size of the warehouse to reduce the spillage.
C
The Snowflake console has timed-out. Contact Snowflake Support.
D
The warehouse consists of a single cluster. Use a multi-cluster warehouse to reduce the spillage.
No comments yet.