JSON

JSON_QUERY

BigQuery

Mengekstrak JSON value menggunakan JSONPath (SQL standard compliant).

Tipe hasil: JSONDiperbarui: 7 Jan 2026

Syntax

SQL

JSON_QUERY(json_expression, json_path)

json_expressionJSONwajib

Nilai JSON

json_pathSTRINGwajib

JSONPath expression

SQL

1 SELECT
2   JSON_QUERY(JSON '{"user": {"name": "John"}}', '$.user') as user_obj,
3   JSON_QUERY(JSON '{"items": [1, 2, 3]}', '$.items') as items;

Mengekstrak object dan array dari JSON.

Hasil

user_obj	items
{"name": "John"}	[1,2,3]

1	SELECT
2	JSON_QUERY(JSON '{"user": {"name": "John"}}', '$.user') as user_obj,
3	JSON_QUERY(JSON '{"items": [1, 2, 3]}', '$.items') as items;