Snowflake automatically captures min/max metadata for every column across all micro-partitions. When a query executes, the Cloud Services layer performs to scan only the micro-partitions containing relevant data. Consequently, your physical data model must align with common query filter patterns to maximize pruning efficiency. 2. Structural Frameworks for Snowflake