SSC-EWI-0040

Statement Not Supported.

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 [e-mail]