JSON

JSON_KEYS

BigQuery

Mengembalikan array berisi semua keys dari JSON object.

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

Syntax

SQL

JSON_KEYS(json_expression)

json_expressionJSONwajib

JSON object

SQL

1 SELECT
2   JSON_KEYS(JSON '{"name": "John", "age": 30, "city": "NYC"}') as keys;

Mengekstrak semua keys dari JSON object.

Hasil

keys
["name", "age", "city"]

SQL

1 SELECT *
2 FROM `project.dataset.data`
3 WHERE 'email' IN UNNEST(JSON_KEYS(metadata));

Filter records yang memiliki key 'email' dalam metadata.

JSON_KEYS

MySQL

OBJECT_KEYS

Snowflake

JSON_KEYS

DuckDB

1	SELECT
2	JSON_KEYS(JSON '{"name": "John", "age": 30, "city": "NYC"}') as keys;

1	SELECT *
2	FROM `project.dataset.data`
3	WHERE 'email' IN UNNEST(JSON_KEYS(metadata));