JSON_CHECK

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

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

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 UPPER(RTRIM(IFNULL(CHECK_JSON('{}'), 'OK'))) = UPPER(RTRIM('OK'))
THEN 'OKK' ELSE 'NOT OK'
END;

Known Issues

No issues were found.

Related EWIs

No related EWIs.