Data Eng & Infrastructure
The Missing Manual: Everything you need to know about Snowflake optimization
In this talk, we’ll cover everything you need to know about cost and performance optimization in Snowflake. We’ll start with a deep dive into Snowflake’s architecture & billing model, covering key concepts like virtual warehouses, micro-partitioning, the lifecycle of a query and Snowflake’s two-tiered cache. We’ll go in depth on the most important optimization strategies, like virtual warehouse configuration, table clustering and query writing best practices. Throughout the talk, we’ll share code snippets and other resources you can leverage to get the most out of Snowflake.