snowflake.snowpark.functions.array_construct_compact¶

snowflake.snowpark.functions.array_construct_compact(*cols: Union[Column, str]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.16.0/src/snowflake/snowpark/functions.py#L5316-L5342)¶

Returns an ARRAY constructed from zero, one, or more inputs. The constructed ARRAY omits any NULL input values.

Parameters:

cols – Columns containing the values (or expressions that evaluate to values). The values do not all need to be of the same data type.

Example::

CopyExpand

>>> df = session.create_dataframe([[1, None, 2], [3, None, 4]], schema=["a", "b", "c"])
>>> df.select(array_construct_compact("a", "b", "c").alias("result")).show()
------------
|"RESULT"  |
------------
|[         |
|  1,      |
|  2       |
|]         |
|[         |
|  3,      |
|  4       |
|]         |
------------

Show lessSee more

Scroll to top