JSON

JSON_EXTRACT

BigQuery

Mengekstrak nilai dari JSON menggunakan JSONPath dan mengembalikan sebagai JSON.

Tipe hasil: JSONDiperbarui: 7 Jan 2026

Syntax

SQL

JSON_EXTRACT(json_expression, json_path)

Parameter

json_expressionJSON/STRINGwajib

String JSON atau nilai JSON

json_pathSTRINGwajib

JSONPath expression (dimulai dengan $)

Contoh Penggunaan

Ekstrak Field dari JSON

SQL

1 SELECT
2   JSON_EXTRACT('{"name": "John", "age": 30}', '$.name') as name_json,
3   JSON_EXTRACT('{"items": [1, 2, 3]}', '$.items[0]') as first_item;

Mengekstrak field dan array element.

Hasil

name_json	first_item
"John"	1

Nested JSON Extraction

SQL

1 SELECT
2   JSON_EXTRACT(data, '$.user.address.city') as city
3 FROM `project.dataset.events`;

Mengakses nested object dalam JSON.

Fungsi Equivalen di Database Lain

JSON_EXTRACT_PATH

PostgreSQL

JSON_EXTRACT

MySQL

GET_PATH

Snowflake

JSON_EXTRACT

DuckDB

Fungsi Terkait

JSON_VALUEJSON_QUERY

Kembali ke BigQuery Functions

1	SELECT
2	JSON_EXTRACT('{"name": "John", "age": 30}', '$.name') as name_json,
3	JSON_EXTRACT('{"items": [1, 2, 3]}', '$.items[0]') as first_item;

1	SELECT
2	JSON_EXTRACT(data, '$.user.address.city') as city
3	FROM `project.dataset.events`;