Which of the below query will you run to get the approximate number of distinct values in a table?

Which of the below query will you run to get the approximate number of distinct values in a table?
A . select approx_count_distinct(column1) from table1;
B. select approx_count(column1) from table1;
C. select count_distinct(column1 approx) from table1;

View Answer

Answer: A

Explanation:

APPROX_COUNT_DISTINCT

Uses HyperLogLog to return an approximation of the distinct cardinality of the input (i.e. HLL(col1, col2, … ) returns an approximation of COUNT(DISTINCT col1, col2, … )). https://docs.snowflake.com/en/sql-reference/functions/approx_count_distinct.html#approx-count-distinct