In this episode of “Behind the Cape,” Data Superheroes Ian Whitestone and Keith Belanger continue their discussion about Snowflake query optimization with a focus on Micro-partitions, Pruning and Clustering. Cost is always top of mind for many organizations when using Snowflake. Ian shares techniques and features to help you understand the performance of your query and offers ways to break down the query and suggestions to better understand what may be able to be done to improve the performance and cost of your queries.
Following are links to blogs referenced in the video:
→ https://select.dev/posts/introduction-to-snowflake-clustering
→ https://select.dev/posts/introduction-to-snowflake-micro-partitions
Function to check clustering health:
→ https://docs.snowflake.com/en/sql-reference/functions/system_clustering_information#examples
To view Part 1 of this conversation with Ian Whitestone, click here:
→ https://www.youtube.com/watch?v=xC5ijNM3u-U
To view Part 2 of this conversation with Ian Whitestone, click here:
→ https://www.youtube.com/watch?v=8lIHyCuTac8