JSON

JSON_KEYS

DuckDB

Mengembalikan array berisi semua keys dari JSON object. Opsional bisa menentukan path ke nested object.

Tipe hasil: VARCHAR[] (array of strings)Diperbarui: 6 Jan 2026

Syntax

SQL

JSON_KEYS(json [, path])

jsonJSON/VARCHARwajib

Data JSON object

pathVARCHARopsional

Opsional. Path ke nested object

SQL

1 SELECT JSON_KEYS('{"name": "John", "age": 30, "city": "Jakarta"}');

Mengembalikan array semua keys.

Hasil

[name, age, city]

SQL

1 SELECT JSON_KEYS('{"user": {"name": "John", "email": "john@example.com"}}', '$.user');

Mengambil keys dari nested object 'user'.

Hasil

[name, email]

SQL

1 SELECT
2   JSON_KEYS(metadata) as available_fields,
3   COUNT(*) as count
4 FROM products
5 GROUP BY JSON_KEYS(metadata);

Menganalisis variasi schema JSON di tabel.

JSON_KEYS

MySQL

OBJECT_KEYS

Snowflake

JSON_KEYS

BigQuery

1	SELECT
2	JSON_KEYS(metadata) as available_fields,
3	COUNT(*) as count
4	FROM products
5	GROUP BY JSON_KEYS(metadata);