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

snowflake.snowpark.functions.array_compact¶

snowflake.snowpark.functions.array_compact(array: ColumnOrName) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/release-v1.3.0/src/snowflake/snowpark/functions.py#L3553-L3561)¶

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