MSCEWI3009

JSON_TABLE is not supported.

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

Severity

High

Description

JSON_TABLE function is not currently supported.

Example Code

Input Code:

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

Output Code:

SELECT jt.phones
FROM MYDB.PUBLIC.j_purchaseorder, /*** MSC-ERROR - MSCEWI3009 - 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 JASON_TABLE.

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