DE, according to the doc
https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions
Snowflake stores metadata about all rows stored in a micro-partition, including:
The range of values for each of the columns in the micro-partition.
The number of distinct values.
Additional properties used for both optimization and efficient query processing.
AD according to my testing
I ran the following queries. Only COUNT (DISTINCT) used the warehouse. Scanned only 1 partition. This contradicts the documentation>
select min(cc_call_center_sk) from snowflake_sample_data.tpcds_sf100tcl.call_center;
select max(cc_call_center_sk) from snowflake_sample_data.tpcds_sf100tcl.call_center;
select count(distinct cc_call_center_sk) from snowflake_sample_data.tpcds_sf100tcl.call_center;
select count(*) from snowflake_sample_data.tpcds_sf100tcl.call_center;
Also see related Q157
Snowflake stores metadata about all rows stored in a micro-partition, including the range of values for each of the columns in the micro-partition and the number of distinct values
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.
0e504b5
9 months agokayuhanbiduk
1 year agoHeetec
1 year, 1 month ago