Comment on page
MSCEWI4041
XML data type methods are not supported in Snowflake.
Medium
- Value
- Query
- Exist
- Modify
- Nodes
SELECT CatalogDescription.query('SomeXMLString') as Result
FROM Production.ProductModel
SELECT
-- ** MSC-ERROR - MSCEWI4041 - XML TYPE METHOD query IS NOT SUPPORTED IN SNOWFLAKE**
-- CatalogDescription.query('SomeXMLString')
as Result
FROM Production.ProductModel;
- 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.