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.
Niall’s data engineering experience spans small start-ups to Fortune 500 companies. In his role at Brooklyn Data Co, Niall consulted on many Snowflake implementations, reducing clients’ Snowflake spend by hundreds of thousands of dollars. In the data community he's well-known for creating and contributing to open source packages. Niall is currently a co-founder at SELECT, a tool to help Snowflake users optimize their Snowflake cost & performance.
Ian is currently a co-founder at SELECT, a tool to help Snowflake users optimize their Snowflake cost & performance. Previously, Ian led data teams at Shopify and Capital One. At Shopify, Ian spearheaded the efforts to reduce their data warehouse spend by over 50%. Since then, he’s consulted on Snowflake cost optimization for multiple companies.