MSCEWI3010

XMLTABLE is not supported.

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

This EWI was removed and replaced by MSCEWI1084

Severity

High

Description

XMLTABLE function is not currently supported.

Example Code

Input Code:

SELECT x.*
FROM XmlTableTest t,
XMLTABLE ('/Employees/Employee'
PASSING t.xmldata
COLUMNS firstname VARCHAR2(30) PATH 'firstname',
lastname VARCHAR2(30) PATH 'lastname') x;

Output Code:

SELECT x.*
FROM MYDB.PUBLIC.XmlTableTest t, /*** MSC-ERROR - MSCEWI3010 - XMLTABLE IS NOT SUPPORTED ***/
XMLTABLE ('/Employees/Employee'
PASSING t.xmldata
COLUMNS firstname VARCHAR(30) PATH 'firstname',
lastname VARCHAR(30) PATH 'lastname') x;

Recommendations

• Check this blog for XML transformations in Snowflake.

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