snowflake.snowpark.functions.concat¶

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

Concatenates one or more strings, or concatenates one or more binary values. If any of the values is null, the result is also null.

Example::

CopyExpand

>>> df = session.create_dataframe([['Hello', 'World']], schema=['a', 'b'])
>>> df.select(concat(df.a, df.b)).show()
--------------------------
|"CONCAT(""A"", ""B"")"  |
--------------------------
|HelloWorld              |
--------------------------

Show lessSee more

Scroll to top