JSON

JSON_STRUCTURE

DuckDB

Menganalisis struktur JSON dan mengembalikan type signature. Sangat berguna untuk schema discovery.

Tipe hasil: VARCHARDiperbarui: 6 Jan 2026

Syntax

SQL

JSON_STRUCTURE(json)

jsonJSON/VARCHARwajib

Data JSON yang akan dianalisis strukturnya

SQL

1 SELECT JSON_STRUCTURE('{"name": "John", "age": 30}');

Melihat struktur object.

Hasil

{"name":"VARCHAR","age":"BIGINT"}

SQL

1 SELECT JSON_STRUCTURE('{"items": [1, 2, 3], "total": 100}');

Struktur dengan array.

Hasil

{"items":["BIGINT"],"total":"BIGINT"}

SQL

1 SELECT DISTINCT JSON_STRUCTURE(metadata) as schema
2 FROM products
3 LIMIT 10;

Menemukan variasi schema di kolom JSON.

SQL

1 SELECT JSON_STRUCTURE('{
2   "user": {"name": "John", "email": "john@example.com"},
3   "orders": [{"id": 1, "amount": 100}]
4 }');

Analisis struktur nested yang kompleks.

Hasil

{"user":{"name":"VARCHAR","email":"VARCHAR"},"orders":[{"id":"BIGINT","amount":"BIGINT"}]}

1	SELECT DISTINCT JSON_STRUCTURE(metadata) as schema
2	FROM products
3	LIMIT 10;

1	SELECT JSON_STRUCTURE('{
2	"user": {"name": "John", "email": "john@example.com"},
3	"orders": [{"id": 1, "amount": 100}]
4	}');