MSCEWI2063
JSON path was not recognized
Medium
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.
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);
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);
- Check if the Json path have an unexpected character, or do not have the right format.
- For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.
Last modified 1yr ago