From the course: Snowflake SnowPro Core Cert Prep

Unlock this course with a free trial

Join today to access over 24,800 courses taught by industry experts.

Micro-partition pruning

Micro-partition pruning - Snowflake Tutorial

From the course: Snowflake SnowPro Core Cert Prep

Start my 1-month free trial Buy for my team

Micro-partition pruning

“

Let's talk about micro-partition pruning. Now, micro-partitions are organized based upon a clustering key. Now, this is automatically selected by Snowflake when you load the data in. So it's ordered in a natural way. So if you're loading data every day into a table and it's based upon order date, for example, the data will be naturally clustered by order date. And if that doesn't match the way that you want to run your queries, you can override that by creating a clustering key on your data and physically ordering and structuring that data in a different way. Now, we've discussed it's a fact that Snowflake's architecture from a data storage perspective is underpinned by these small blocks of data called micro-partitions, and that gives it a distinct performance advantage in many cases. Because the data is organized across these small blocks, we could have potentially thousands and thousands of these partitions for a large table. And this allows for greater flexibility when locating…

Contents