snowflake.snowpark.functions.create_map¶

snowflake.snowpark.functions.create_map(*cols: Union[Column, str, List[Union[Column, str]], Tuple[Union[Column, str]]]) → Column[source]¶

Transforms multiple column pairs into a single map Column where each pair of columns is treated as a key-value pair in the resulting map.

Parameters:

*cols – A variable number of column names or Column objects that can also be expressed as a list of columns. The function expects an even number of arguments, where each pair of arguments represents a key-value pair for the map.

Returns:

A Column where each row contains a map created from the provided column pairs.

Example

>>> from snowflake.snowpark.functions import create_map
>>> df = session.create_dataframe([("Paris", "France"), ("Tokyo", "Japan")], ("city", "country"))
>>> df.select(create_map("city", "country").alias("map")).show()
-----------------------
|"MAP"                |
-----------------------
|{                    |
|  "Paris": "France"  |
|}                    |
|{                    |
|  "Tokyo": "Japan"   |
|}                    |
-----------------------
Copy
>>> df.select(create_map([df.city, df.country]).alias("map")).show()
-----------------------
|"MAP"                |
-----------------------
|{                    |
|  "Paris": "France"  |
|}                    |
|{                    |
|  "Tokyo": "Japan"   |
|}                    |
-----------------------
Copy