JSON

CHECK_JSON

Snowflake

Memeriksa apakah string adalah valid JSON. Mengembalikan NULL jika valid, atau pesan error jika tidak valid.

Tipe hasil: VARCHAR (NULL if valid, error message if invalid)

Syntax

SQL

CHECK_JSON(string)

Parameter

stringVARCHARwajib

String yang akan divalidasi sebagai JSON

Contoh Penggunaan

Validate JSON String

SQL

1 SELECT
2   json_str,
3   CHECK_JSON(json_str) as validation_result,
4   CASE WHEN CHECK_JSON(json_str) IS NULL THEN 'Valid' ELSE 'Invalid' END as status
5 FROM (
6   SELECT '{"name": "John"}' as json_str
7   UNION ALL SELECT '{"invalid": }' as json_str
8   UNION ALL SELECT 'not json' as json_str
9 );

Validasi beberapa string JSON.

Hasil

json_str	validation_result	status
{"name": "John"}	NULL	Valid
{"invalid": }	unexpected character...	Invalid
not json	invalid JSON...	Invalid

Fungsi Equivalen di Database Lain

JSON_VALID

MySQL

JSON_VALID

DuckDB

Fungsi Terkait

TRY_PARSE_JSON

Kembali ke Snowflake Functions

1	SELECT
2	json_str,
3	CHECK_JSON(json_str) as validation_result,
4	CASE WHEN CHECK_JSON(json_str) IS NULL THEN 'Valid' ELSE 'Invalid' END as status
5	FROM (
6	SELECT '{"name": "John"}' as json_str
7	UNION ALL SELECT '{"invalid": }' as json_str
8	UNION ALL SELECT 'not json' as json_str
9	);