json_items¶

Signature

json_items(json_string)

Description

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

Examples

EUUSeurope-west1

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

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

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

+-----------------------------------------------------------------------------------------------------+
| key_value_items                                                                                     |
+-----------------------------------------------------------------------------------------------------+
| [
|   struct("created_at" as key, "date" as value),
|   struct("user" as key, "name" as value)
| ]
 |
+-----------------------------------------------------------------------------------------------------+