JSON

JSON_EXTRACT_SCALAR

BigQuery

Mengekstrak nilai scalar dari JSON dan mengembalikan sebagai STRING.

Tipe hasil: STRINGDiperbarui: 7 Jan 2026

Syntax

SQL

JSON_EXTRACT_SCALAR(json_expression, json_path)

Parameter

json_expressionJSON/STRINGwajib

String JSON atau nilai JSON

json_pathSTRINGwajib

JSONPath expression

Contoh Penggunaan

Scalar Extraction

SQL

1 SELECT
2   JSON_EXTRACT_SCALAR('{"name": "John", "age": 30}', '$.name') as name_string,
3   JSON_EXTRACT('{"name": "John"}', '$.name') as name_json;

Perbandingan SCALAR (tanpa quotes) vs regular (dengan quotes).

Hasil

name_string	name_json
John	"John"

Extract and Cast

SQL

1 SELECT
2   CAST(JSON_EXTRACT_SCALAR(data, '$.price') AS FLOAT64) as price
3 FROM `project.dataset.products`;

Ekstrak dan konversi ke tipe numerik.

Kembali ke BigQuery Functions

1	SELECT
2	JSON_EXTRACT_SCALAR('{"name": "John", "age": 30}', '$.name') as name_string,
3	JSON_EXTRACT('{"name": "John"}', '$.name') as name_json;

1	SELECT
2	CAST(JSON_EXTRACT_SCALAR(data, '$.price') AS FLOAT64) as price
3	FROM `project.dataset.products`;