Links
Comment on page

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.
  • If you need more support, you can email us at [email protected]