You are viewing documentation about an older version (1.1.0). View latest version

snowflake.snowpark.functions.approx_count_distinct

snowflake.snowpark.functions.approx_count_distinct(e: ColumnOrName) Column[source] (https://github.com/snowflakedb/snowpark-python/blob/release-v1.1.0/src/snowflake/snowpark/functions.py#L474-L478)

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, … )).