SSC-EWI-TD0057
Binary data in NEW JSON is not supported
Severity
Low
Description
The NEW JSON function accepts the JSON data represented as a string or in binary format. when the data is in its binary representation the function is not transformed since this binary format is not valid in Snowflake because it cannot interpret the metadata about the JSON object, for more information about this please see Teradata NEW JSON documentation.
Example Code
Input Code
SELECT NEW JSON ('160000000268656C6C6F0006000000776F726C640000'xb, BSON);
Output Code
SELECT
!!!RESOLVE EWI!!! /*** SSC-EWI-TD0057 - NEW JSON FUNCTION WITH BINARY DATA IS NOT SUPPORTED ***/!!!!!!RESOLVE EWI!!! /*** SSC-EWI-TD0039 - INPUT FORMAT 'BSON' NOT SUPPORTED ***/!!!
NEW JSON (TO_BINARY('160000000268656C6C6F0006000000776F726C640000'), BSON);
Recommendations
If you need more support, you can email us at snowconvert-support@snowflake.com
Last updated