SSC-EWI-0040

Statement Not Supported.

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 Documentation

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

Thank you for your understanding.

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

Severity

Low

Description

This warning is added when there is a statement that is not supported in SnowFlake.

Example Code

In the following example, the PERCENT clause from SQL Server is used on the SELECT query, this is not supported by Snowflake.

Input Code (SQL Server):

IN -> SqlServer_01.sql

SELECT TOP 1 PERCENT * FROM SampleTable;

Source Code:

OUT -> SqlServer_01.sql

// SnowConvert Helpers Code section is omitted.
SELECT
TOP 1 !!!RESOLVE EWI!!! /*** SSC-EWI-0040 - THE STATEMENT IS NOT SUPPORTED IN SNOWFLAKE ***/!!!
*
FROM
SampleTable;

Recommendations

• Review the original functionality of the statement and check if it is actually needed for your specific needs in Snowflake.

• If you need more support, you can email us at [email protected]