Excessive spillage in the Query Profile—where intermediate data “spills” from RAM to SSD or even remote cloud storage—means your warehouse ran out of memory for the query. In other words, it’s a clear sign of improper virtual warehouse sizing (option C), not an issue with CTEs, temporary tables, or general query logic.
When a warehouse’s RAM is exhausted during sorts, joins, or aggregations, Snowflake writes intermediate blocks to local SSD (and then to remote storage if needed), which shows up as high “Bytes Spilled” in the profile.
Spillage to local or remote storage drastically slows execution and indicates you need a larger warehouse (more memory) to keep data in‑memory.
Snowflake documentation and community best practices uniformly recommend increasing warehouse size if you observe significant spillage metrics.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Billhardy
2Â weeks agoywan1600
2Â months, 1Â week agobor4un
3Â months, 1Â week ago37ceea2
3Â months ago37ceea2
2Â months, 3Â weeks agobor4un
3Â months, 1Â week ago