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

snowflake.snowpark.functions.sum_distinct¶

snowflake.snowpark.functions.sum_distinct(e: Column | str) → Column[source]¶

Returns the sum of non-NULL distinct records in a group. You can use the DISTINCT keyword to compute the sum of unique non-null values. If all records inside a group are NULL, the function returns NULL.

Example::

>>> df = session.create_dataframe(
...     [1, 2, None, 3],
...     schema=["N"],
... ).select(sum_distinct(col("N")))
>>> df.collect()
[Row(SUM( DISTINCT "N")=6)]