snowflake.snowpark.functions.boolor_agg¶

snowflake.snowpark.functions.boolor_agg(expr: Union[snowflake.snowpark.column.Column, str]) → Column[source]¶

Returns the logical OR of all non-NULL records in a group. If all records are NULL, returns NULL.

Parameters:: expr (ColumnOrName) – Boolean values to aggregate.
Returns:: The logical OR aggregation result.
Return type:: Column

Example:

>>> df = session.create_dataframe([
...     [True, False, True],
...     [False, False, False],
...     [True, True, False],
...     [False, True, True]
... ], schema=["a", "b", "c"])
>>> df.select(
...     boolor_agg(df["a"]).alias("boolor_a"),
...     boolor_agg(df["b"]).alias("boolor_b"),
...     boolor_agg(df["c"]).alias("boolor_c")
... ).collect()
[Row(BOOLOR_A=True, BOOLOR_B=True, BOOLOR_C=True)]