JSON

JSON_VALUE_ARRAY

BigQuery

Mengekstrak array of scalars dari JSON native sebagai ARRAY<STRING>.

Tipe hasil: ARRAY<STRING>Diperbarui: 7 Jan 2026

Syntax

SQL

JSON_VALUE_ARRAY(json_expression [, json_path])

json_expressionJSONwajib

Nilai JSON native

json_pathSTRINGopsional

JSONPath ke array

SQL

1 SELECT
2   JSON_VALUE_ARRAY(JSON '["a", "b", "c"]') as letters;

Mengekstrak array of strings.

Hasil

letters
["a","b","c"]

1	SELECT
2	JSON_VALUE_ARRAY(JSON '["a", "b", "c"]') as letters;