JSON

JSON_EXTRACT_STRING_ARRAY

BigQuery

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

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

Syntax

SQL

JSON_EXTRACT_STRING_ARRAY(json_expression [, json_path])

json_expressionJSON/STRINGwajib

String JSON atau nilai JSON

json_pathSTRINGopsional

JSONPath ke array

SQL

1 SELECT
2   JSON_EXTRACT_STRING_ARRAY('{"tags": ["sql", "bigquery", "data"]}', '$.tags') as tags;

Mengekstrak array of strings langsung.

Hasil

tags
["sql", "bigquery", "data"]

SQL

1 SELECT *
2 FROM `project.dataset.posts`
3 WHERE 'featured' IN UNNEST(JSON_EXTRACT_STRING_ARRAY(metadata, '$.tags'));

Filter posts yang memiliki tag 'featured'.

1	SELECT
2	JSON_EXTRACT_STRING_ARRAY('{"tags": ["sql", "bigquery", "data"]}', '$.tags') as tags;

1	SELECT *
2	FROM `project.dataset.posts`
3	WHERE 'featured' IN UNNEST(JSON_EXTRACT_STRING_ARRAY(metadata, '$.tags'));