Road to Snowflake SnowPro Core Certification: Cache & Query Performance

Twelfth Chapter: Cache and Query Performance

Chapter 12: Snowflake Cache and Query Performance.

One of the most important concepts is the cache to improve the speed of our queries in Snowflake and optimize costs. In this chapter, we will study the existing ones (Metadata, Query Result, and Warehouse cache) and some tips to improve Snowflake’s performance.

1. Metadata Cache
2. Query Result Cache
3. Warehouse Cache
4. Complete example of the Snowflake caches
5. How to improve Snowflake performance
6. Typical exam questions on Snowflake caches

Remember that all the chapters from the course can be found in the following link:

Road to SnowFlake SnowPro Core Certification: Complete Course

METADATA CACHE

Metadata caching is maintained in Global Service Layer and contains Objects Information & Statistics. As we mentioned in the chapter about micro-partitions, Snowflake automatically stores different types of metadata to improve the…