JSON_CHECK

Translation reference to convert the Teradata function JSON_CHECK to Snowflake Scripting.

Description

The JSON_CHECK function checks a string for valid JSON.

For more information regarding Teradata JSON_CHECK, check here.

[TD_SYSFNLIB.]JSON_CHECK(string_expr);

Sample Source Pattern

Basic Source Pattern

Teradata

Query

SELECT JSON_CHECK('{"key": "value"}');

Snowflake Scripting

Query

CHECK_JSON('{"key": "value"}');

JSON_CHECK inside CASE transformation

Teradata

Query

SELECT CASE WHEN JSON_CHECK('{}') = 'OK' then 'OKK' ELSE 'NOT OK' END;

Snowflake Scripting

Query

SELECT CASE WHEN CHECK_JSON('{}') IS NULL then 'OKK' ELSE 'NOT OK' END;