MAP_KEYS

Learn how to use the MAP_KEYS map function in PlaidCloud Lakehouse. Returns the keys in a map. Includes detailed syntax, examples, and usage reference.

Returns the keys in a map.

SQL Syntax

MAP_KEYS( <map> )

Arguments

ArgumentsDescription
<map>The input map.

Return Type

Array.

SQL Examples

SELECT MAP_KEYS({'a':1,'b':2,'c':3});

┌───────────────────────────────┐
│ map_keys({'a':1,'b':2,'c':3}) │
├───────────────────────────────┤
│ ['a','b','c']                 │
└───────────────────────────────┘