There are some really cool details about Snowflake’s clustering. Working with these details can help reduce the cost of clustering. In the last article, I dug into how aligning a clustering key with data arrival patterns can help you reduce…
Choosing a clustering key isn’t just about which columns or functions to include — it’s about how your data arrives. In most real-world systems, data lands in approximate or exact date order. That arrival pattern interacts with your clustering key…
One of the most basic building blocks of Snowflake query performance is partition pruning. Let’s explore partition pruning, identifying when it is occurring, and why it matters for query performance. Micro-Partitions Snowflake stores data in micro-partitions. Micro-partitions are proprietarily structured…
I’ve spent 20 years of my career working with IBM Db2, then a year working with MySQL, and now my database platform of choice is Snowflake. When I was moving from Db2 to MySQL, there were a number of “WTH?”…
