This is a deprecated version of the SnowConvert documentation, please visit the official site .
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 function in Snowflake to emulate the functionality of JASON_TABLE.