When a Snowflake virtual warehouse is resized, the data cached in the warehouse is not lost. This is because the cache is maintained independently of the warehouse size. Resizing a warehouse, whether scaling up or down, does not affect the cached data, ensuring that query performance is not impacted by such changes.
[References:, [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation onVirtual Warehouse Performance1, , , ]
Submit