snowflake.snowpark.functions.array_max¶

snowflake.snowpark.functions.array_max(array: Union[Column, str]) → Column[source]¶

Returns largest defined non-NULL element in the input array. If the input array is empty, or there is no defined element in the input array, then the function returns NULL.

Must enable parameter ENABLE_ARRAY_MIN_MAX_FUNCTIONS in your session.

Parameters:

array – the input array

Returns:

a VARIANT containing the largest defined element in the array, or NULL