Road to Snowflake SnowPro Core Certification: Cache & Query Performance

Twelfth Chapter: Cache and Query Performance

Gonzalo Fernandez Plaza
8 min readOct 5, 2021

--

Chapter 12: Snowflake 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:

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…

--

--

Gonzalo Fernandez Plaza

Computer Science Engineer & Tech Lead 🖥️. Publishing AWS & Snowflake ❄️ courses & exams. https://www.fullcertified.com