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

IN -> Teradata_01.sql

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

Snowflake Scripting

Query

OUT -> Teradata_01.sql

SELECT
IFNULL(CHECK_JSON('{"key": "value"}'), 'OK');

JSON_CHECK inside CASE transformation

Teradata

Query

IN -> Teradata_02.sql

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

Snowflake Scripting

Query

OUT -> Teradata_02.sql

SELECT
CASE
WHEN IFNULL(CHECK_JSON('{}'), 'OK') = 'OK'
THEN 'OKK' ELSE 'NOT OK'
END;