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

snowflake.snowpark.functions.array_unique_agg

snowflake.snowpark.functions.array_unique_agg(col: Union[Column, str]) Column[source]

Returns a Column containing the distinct values in the specified column col. The values in the Column are in no particular order, and the order is not deterministic. The function ignores NULL values in col. If col contains only NULL values or col is empty, the function returns an empty Column.

Parameters:

col – A Column object or column name that determines the values.

Example::
>>> df = session.create_dataframe([[5], [2], [1], [2], [1]], schema=["a"])
>>> df.select(array_unique_agg("a").alias("result")).show()
------------
|"RESULT"  |
------------
|[         |
|  5,      |
|  2,      |
|  1       |
|]         |
------------
Copy