MSCEWI2063

JSON path was not recognized

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Medium

Description

This message is shown when SnowConvert cannot deserialize a Json path, because the string does not have the expected format or is not supported in snowflake.

Example code

Input Code:

SELECT
*
FROM 
 JSON_TABLE
(ON (SELECT id, 
trainSchedule as ts
FROM demo.PUBLIC.Train T)
USING rowexpr('$weekShedule.Monday[*]')
      colexpr('[{"jsonpath"  "$.time",
                  "type"" : "CHAR ( 12 )"}]'))
AS JT(Id, Ordinal, Time, City);

Output Code:

SELECT
*
FROM/*** MSC-ERROR - MSCEWI2063 - UNRECOGNIZED JSON PATH $weekShedule.Monday[*] ***/
JSON_TABLE
(ON (SELECT
id,
trainSchedule as ts
FROM demo.PUBLIC.Train T)
USING rowexpr('$weekShedule.Monday[*]')
      colexpr('[{"jsonpath"  "$.time",
                  "type"" : "CHAR ( 12 )"}]'))
AS JT(Id, Ordinal, Time, City);

Recommendations

• Check if the Json path have an unexpected character, or do not have the right format.

• If you need more support, you can email us at [email protected]