SSC-EWI-TS0044

FOR XML clause is not supported in Snowflake.

circle-info

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentationarrow-up-right

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected]envelope.

Thank you for your understanding.

Severity

Critical

circle-info

Some parts of the output code are omitted for clarity reasons.

Description

This EWI is added for the FOR XML arrow-up-rightclause which is not supported in Snowflake SQL

Code Example

Input Code:

IN -> SqlServer_01.sql
SELECT TOP 1 LastName
FROM AdventureWorks2019.Person.Person
FOR XML AUTO;

Output Code:

Recommendations

  • Consider using UDFs to emulate the behavior of the source code. The following code provides suggestions of UDFs that can be used to achieve recreating the original behavior:

SQL Server

Snowflake

Last updated