Snowflake organizes table data into immutable micro‑partitions—small (50–500 MB uncompressed, up to 16 MB compressed) columnar files stored in cloud blob storage—where each partition’s columns are sorted and compressed independently. At query compile time, Snowflake uses per‑partition metadata (min/max values, distinct counts, byte offsets) to prune irrelevant partitions and skip unreferenced columns, drastically reducing I/O and network reads.
https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions
The micro-partition metadata maintained by Snowflake enables precise pruning of columns in micro-partitions at query run-time, including columns containing semi-structured data.
These being said, it seems that pruning is done by column in micro-partitions, which is against all the questions we solved in this examtopics. I shall say that B, but I am not convinced anymore.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Billhardy
2Â weeks ago37ceea2
3Â months ago