bigfunctions > json_values

json_values

Signature

json_values(json_string)

Description

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

Examples

EUUSeurope-west1

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

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

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

+--------------------------+
| values                   |
+--------------------------+
| ['2022-01-01', 'sidali'] |
+--------------------------+