snowflake.snowpark.functions.map_keys

snowflake.snowpark.functions.map_keys(col: Union[Column, str])[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.30.0/snowpark-python/src/snowflake/snowpark/functions.py#L7406-L7427)

Returns the keys in a MAP.

Parameters:

col – The input map.

Example 1::
>>> df = session.sql("select {'k1': 'v1', 'k2': 'v2'} :: MAP(STRING,STRING) as M")
>>> df.select(map_keys("M")).show()
---------------------
|"MAP_KEYS(""M"")"  |
---------------------
|[                  |
|  "k1",            |
|  "k2"             |
|]                  |
---------------------
Copy
Language: English