https://docs.snowflake.net/manuals/user-guide/tables-micro-partitions.html
snowflake-doc-micro-partitiong#range-of-values-in-micro-partition1Snowflake automatically gathers metadata about all rows stored in a micro-partition, including: range of values for each of the columns in the micro-partition snowflake-doc-micro-partitiong#range-of-values-in-micro-partition1
snowflake-doc-micro-partitiong#query-pruning-on-micropartitions1 2The micro-partition metadata maintained by Snowflake enables precise pruning of columns in micro-partitions at query run-time, including columns containing semi-structured data. In other words, a query that specifies a filter predicate on a range of values that accesses 10% of the values in the range should ideally only scan 10% of the micro-partitions. snowflake-doc-micro-partitiong#query-pruning-on-micropartitions1 2
snowflake-doc-micro-partitiong#colocation1Snowflake automatically sorts data as it is inserted/loaded into a table. Data with the same values is co-located, as much as possible, in the same micro-partition. snowflake-doc-micro-partitiong#colocation1
snowflake-doc-micro-partitiong#constant-state1When there is no overlap in the range of values across all micro-partitions, the micro-partitions are considered to be in a constant state (i.e. they cannot be improved by reclustering) and table has a clustering ratio of 100. In this case, the table is considered to be fully clustered. snowflake-doc-micro-partitiong#constant-state1