snowflake.snowpark.functions.map_keys¶

snowflake.snowpark.functions.map_keys(col: Union[Column, str])[source]¶

Returns the keys in a MAP.

Parameters:

col – The input map.

Example 1::

CopyExpand

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

Show lessSee more

Scroll to top