snowflake.snowpark.functions.collect_list¶

snowflake.snowpark.functions.collect_list(col: Union[Column, str], is_distinct: bool = False) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.30.0/snowpark-python/src/snowflake/snowpark/functions.py#L6821-L6844)¶

Returns the input values, pivoted into an ARRAY. If the input is empty, an empty ARRAY is returned.

Example::

CopyExpand

>>> df = session.create_dataframe([[1], [2], [3], [1]], schema=["a"])
>>> df.select(array_agg("a", True).within_group("a").alias("result")).show()
------------
|"RESULT"  |
------------
|[         |
|  1,      |
|  2,      |
|  3       |
|]         |
------------

Show lessSee more

Scroll to top