When a query in Snowflake is too large to fit into the available memory, it will start spilling to remote storage. This is an indication that the memory allocated for the query is insufficient for its execution, and as a result, Snowflake uses remote disk storage to handle the overflow. This spill to remote storage can lead to slower query performance due to the additional I/O operations required.
[References:, [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation on Query Profile1, Snowpro Core Certification Exam Flashcards2, , ]
Submit