What are Micro-partitions?

In Snowflake, a micro-partition is a compact, self-contained data storage unit within a table. Think of a table as an assembly of individual pages, with each page serving as a representation of a micro-partition.Every micro-partition houses a range of uncompressed data spanning from 50 MB to 500 MB. in this caseIt enables the achievement of highly precise pruning in the case of exceptionally large tables, which can encompass millions, or even hundreds of millions, of micro-partition.

Talk to US