SSC-EWI-TD0063

JSON path was not recognized

Severity

Medium

Description

This message is shown when SnowConvert cannot deserialize a JSON path because the string does not have the expected JSON format.

Example code

Input Code:

IN -> Teradata_01.sql

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:

OUT -> Teradata_01.sql

SELECT
    *
FROM
    !!!RESOLVE EWI!!! /*** SSC-EWI-TD0096 - UNRECOGNIZED JSON PATH $weekShedule.Monday[*] ***/!!!
JSON_TABLE (
    ON
       !!!RESOLVE EWI!!! /*** SSC-EWI-0108 - THE FOLLOWING SUBQUERY MATCHES AT LEAST ONE OF THE PATTERNS CONSIDERED INVALID AND MAY PRODUCE COMPILATION ERRORS ***/!!! (
           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 [e-mail]