JSON

JSON_VALID

DuckDB

Mengecek apakah string adalah JSON yang valid. Mengembalikan true/false.

Tipe hasil: BOOLEANDiperbarui: 6 Jan 2026

Syntax

SQL

JSON_VALID(json_string)

Parameter

json_stringVARCHARwajib

String yang akan dicek validitas JSON-nya

Contoh Penggunaan

Validasi JSON

SQL

1 SELECT
2   JSON_VALID('{"name": "John"}') as valid_json,
3   JSON_VALID('not a json') as invalid_json,
4   JSON_VALID('[1, 2, 3]') as valid_array;

Mengecek validitas berbagai string.

Hasil

valid_json	invalid_json	valid_array
true	false	true

Filter JSON Valid

SQL

1 SELECT *
2 FROM raw_data
3 WHERE JSON_VALID(json_column);

Hanya mengambil baris dengan JSON valid.

Data Quality Check

SQL

1 SELECT
2   COUNT(*) as total,
3   SUM(CASE WHEN JSON_VALID(metadata) THEN 1 ELSE 0 END) as valid_count,
4   SUM(CASE WHEN NOT JSON_VALID(metadata) THEN 1 ELSE 0 END) as invalid_count
5 FROM products;

Menghitung berapa data JSON yang valid vs invalid.

Fungsi Equivalen di Database Lain

JSON_VALID

MySQL

CHECK_JSON

Snowflake

Kembali ke DuckDB Functions

1	SELECT
2	JSON_VALID('{"name": "John"}') as valid_json,
3	JSON_VALID('not a json') as invalid_json,
4	JSON_VALID('[1, 2, 3]') as valid_array;

1	SELECT
2	COUNT(*) as total,
3	SUM(CASE WHEN JSON_VALID(metadata) THEN 1 ELSE 0 END) as valid_count,
4	SUM(CASE WHEN NOT JSON_VALID(metadata) THEN 1 ELSE 0 END) as invalid_count
5	FROM products;