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