MSCEWI1084

XMLTABLE is not supported.

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.
For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.
​

MSCEWI1083

MSCEWI1086

Last modified 7mo ago