SSC-EWI-OR0009

JSON_TABLE is not supported.

Severity

High

Description

JSON_TABLE function is not currently supported.

Example Code

Input Code:

IN -> Oracle_01.sql

SELECT jt.phones
FROM j_purchaseorder,
JSON_TABLE(po_document, '$.ShippingInstructions'
COLUMNS
(phones VARCHAR2(100) FORMAT JSON PATH '$.Phone')) AS jt;

Output Code:

OUT -> Oracle_01.sql

SELECT jt.phones
FROM
j_purchaseorder,
!!!RESOLVE EWI!!! /*** SSC-EWI-OR0009 - JSON_TABLE IS NOT SUPPORTED ***/!!!
JSON_TABLE(po_document, '$.ShippingInstructions'
COLUMNS
(phones VARCHAR(100) FORMAT JSON PATH '$.Phone')) AS jt;

Recommendations

• You can take advantage of the FLATTEN function in Snowflake to emulate the functionality of JSON_TABLE.

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