All the latest Snowflake learnings, live and direct from two data practitioners.
The Snowflake Query Profile is the single best resource you have to understand how Snowflake is executing your query and learn how to improve it. In this post we cover important topics like how to interpret the Query Profile and the things you should look for when diagnosing poor query performance.
Snowflake users enjoy a lot of flexibility when it comes to compute configuration. In this post we cover the implications of virtual warehouse sizing on query speeds, and share some techniques to determine the right one.
How to effectively utilize Snowflake’s materialized views to allow your table to have multiple, separate cluster keys.
Pairing query design with effective clustering can dramatically improve pruning and query speeds. We'll explore how and when you should leverage this powerful Snowflake feature.
Independently scalable compute and storage is an architecture fundamental of Snowflake. In this post, we’ll be focusing on how Snowflake stores data, and how it can greatly accelerate query performance.
In this Coalesce 2022 presentation, Ian Whitestone and Jonathan Talmi share their experience reducing Snowflake data warehouse spend and performing various Snowflake optimization techniques.
Snowflake's zero-copy cloning feature is extremely powerful for quickly creating production replica environments. But, anyone who has cloned a database or schema with a large number of tables has experienced that it can take over ten minutes to complete. In this post we explore a potential solution.
Understanding the cost of each query in your Snowflake virtual warehouses is critical for cost management. This post provides a detailed overview and working code to help you calculate cost per query.
Ian gives a dive deep presentation into Snowflake’s architecture, the lifecycle of a query, how to use the query profile, optimal warehouse configuration, table clustering and micro-partition pruning. We also get into query best practices & anti-patterns - including some fun things like how to optimize range joins.
An overview of Snowflake's unique elastic data warehouse architecture and its three subcomponents cloud: cloud services, compute and storage