snowflake.snowpark.functions.map_cat

snowflake.snowpark.functions.map_cat(col1: Union[Column, str], col2: Union[Column, str], *cols: Union[Column, str])[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.47.0/src/snowflake/snowpark/functions.py#L7505-L7554)

Returns the concatenatation of two or more MAPs.

Parameters:

  • col1 – The source map

  • col2 – The map to be appended to col1

  • cols – More maps to be appended

Example::
>>> df = session.sql("select {'k1': 'v1'} :: MAP(STRING,STRING) as A, {'k2': 'v2'} :: MAP(STRING,STRING) as B")
>>> df.select(map_cat("A", "B")).show()  
---------------------------
|"MAP_CAT(""A"", ""B"")"  |
---------------------------
|{                        |
|  "k1": "v1",            |
|  "k2": "v2"             |
|}                        |
---------------------------

>>> df = session.sql("select {'k1': 'v1'} :: MAP(STRING,STRING) as A, {'k2': 'v2'} :: MAP(STRING,STRING) as B, {'k3': 'v3'} :: MAP(STRING,STRING) as C")
>>> df.select(map_cat("A", "B", "C")).show()  
-------------------------------------------
|"MAP_CAT(MAP_CAT(""A"", ""B""), ""C"")"  |
-------------------------------------------
|{                                        |
|  "k1": "v1",                            |
|  "k2": "v2",                            |
|  "k3": "v3"                             |
|}                                        |
-------------------------------------------