Cardinality Estimation Functions

pproximate the number of unique elements in a dataset.

APPROX_COUNT_DISTINCT()

Uses HyperLogLog to provide estimate of count distinct

approx_count_distinct(a)
approx_count_distinct(a) over(partition by b)

Limitation -

• " * " is not supported