00:00 Introduction
00:30 Ian's background
01:12 Why should you care about query pruning?
03:16 Architecture of Snowflake
09:59 Types of query pruning
14:39 How to check for query pruning
16:38 When does query pruning work?
18:41 When does query pruning fail?
29:01 Query pruning in practice
40:01 Using SELECT for Snowflake optimization
After warehouse sizing & configuration, building a deep understanding of how micro-partitions & clustering works in Snowflake is the most important thing from an optimization standpoint.
In this talk, I'll cover everything you need to know about query pruning:
- Snowflake's architecture & micro-partitions structure
- How to get your tables into a well-clustered state
- A deep dive into query pruning: when does it work and when does it fail
- Dynamic query pruning