Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?
Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?
Query pruning is a mechanism Snowflake uses to limit the number of micro-partitions scanned by a query. It works by eliminating micro-partitions that cannot possibly contain the data being queried based on metadata, thereby making the query process more efficient.
C correct - https://blog.devgenius.io/snowflake-micro-partitions-clustering-keys-dbt-b6cb1212dcbe