The Missing Manual - Everything You Need to Know About Snowflake Optimization

Dive into a comprehensive 32-minute conference talk on cost and performance optimization in Snowflake. Explore Snowflake's architecture and billing model, covering essential concepts such as virtual warehouses, micro-partitioning, query lifecycle, and the two-tiered cache system. Gain in-depth knowledge of crucial optimization strategies, including virtual warehouse configuration, table clustering, and query writing best practices. Benefit from shared code snippets and resources to maximize Snowflake's potential. Learn from Niall Woodward and Ian Whitestone, co-founders of SELECT, a tool designed to help Snowflake users optimize cost and performance. Discover Niall's contributions to open-source packages and Ian's experience leading data teams at Shopify and Capital One, where he successfully reduced data warehouse spend by over 50%. Presented by Data Council, this talk offers valuable insights for data professionals seeking to enhance their Snowflake optimization skills.

The Missing Manual: Everything You Need to Know about Snowflake Optimization | SELECT