“Bytes spilled to remote storage” indicates the volume of data that couldn’t fit in memory and had to be spilled to a virtual warehouse temporary storage.
For some operations (e.g. duplicate elimination for a huge data set), the amount of memory available for the compute resources used to execute the operation might not be sufficient to hold intermediate results. As a result, the query processing engine will start *spilling* the data to local disk. If the local disk space is not sufficient, the spilled data is then saved to remote disks.
https://docs.snowflake.com/en/user-guide/ui-query-profile.html#queries-too-large-to-fit-in-memory
As a result, the query processing engine will start spilling the data to local disk. If the local disk space is not sufficient, the spilled data is then saved to remote disks.
I agree with Answer D, if query spilling happens , query processing engine start saving the data to local disk if this is not sufficient then it start saving the data to remote disk, this process significantly impact query performance, the solution is use larger size warehouse.
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.
omiiUST
3 months, 2 weeks agoMallikharjuna452
4 months agopranalig
5 months agoAnireddySaikiranReddy
8 months, 3 weeks ago_yyukta
8 months, 4 weeks agoRajuNaik
1 year, 6 months agoc0d3g
1 year, 8 months agowhiteomax
9 months, 2 weeks agoEmiB
1 year, 8 months agoKarBiswa
1 year, 9 months agoJRTanubuddi
1 year, 9 months agoiamPhD
1 year, 10 months agoaalonso
1 year, 11 months agobaig123
1 year, 11 months agokjdfsafc87456
2 years, 2 months agoWilliam_20
2 years, 2 months agoManocs
2 years, 2 months ago