snowflake.snowpark.functions.any_value¶

snowflake.snowpark.functions.any_value(e: Union[Column, str]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.30.0/snowpark-python/src/snowflake/snowpark/functions.py#L670-L681)¶

Returns a non-deterministic any value for the specified column. This is an aggregate and window function.

Example

CopyExpand

>>> df = session.create_dataframe([[1, 2], [3, 4]], schema=["a", "b"])
>>> result = df.select(any_value("a")).collect()
>>> assert len(result) == 1  # non-deterministic value in result.

Show lessSee more

Scroll to top