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 snowconvert-support@snowflake.com
Last updated