bigfunctions > json_keys

json_keys

Signature

json_keys(json_string)

Description

Extract keys from json_string which has only flat (no nested) key-values. Return keys as an array<string>

Examples

EUUSeurope-west1

select bigfunctions.eu.json_keys('{"created_at": "2022-01-01", "user": "sidali"}')

select bigfunctions.us.json_keys('{"created_at": "2022-01-01", "user": "sidali"}')

select bigfunctions.europe_west1.json_keys('{"created_at": "2022-01-01", "user": "sidali"}')

+------------------------+
| keys                   |
+------------------------+
| ['created_at', 'user'] |
+------------------------+