MSCEWI4041

XML data type methods are not supported in Snowflake.

Severity
Medium
Description
This EWI is added for the following XML data type methods that are not supported in Snowflake SQL:
Value
Query
Exist
Modify
Nodes
Code Example
Input Code:
 SELECT CatalogDescription.query('SomeXMLString') as Result
 FROM Production.ProductModel
Output Code:
SELECT
-- ** MSC-ERROR - MSCEWI4041 - XML TYPE METHOD query IS NOT SUPPORTED IN SNOWFLAKE**
--       CatalogDescription.query('SomeXMLString')
as Result
FROM Production.ProductModel;
Recommendations
Consider using UDFs to emulate the behavior of the source code
You can check this documentation and review some possible approaches to work with XML datatypes 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.

MSCEWI4040

MSCEWI4042

Last modified 4mo ago