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

snowflake.snowpark.functions.array_compact

snowflake.snowpark.functions.array_compact(array: ColumnOrName) Column[source]

Returns a compacted ARRAY with missing and null values removed, effectively converting sparse arrays into dense arrays.

Parameters:

array – Column containing the source ARRAY to be compacted