SSC-EWI-0073

Pending Functional Equivalence Review

Severity

Critical

Description

This EWI is added when there is a grammar clause in the input platform that has not been reviewed yet by the SnowConvert developer team, in order to provide support for it in Snowflake. That means that there is currently no translation rule for such grammar, and therefore the whole code of the grammar clause is decorated with this EWI in order to inform the user that this is something that is likely not going to work in Snowflake.

Example Code

SQLServer:

IN -> SqlServer_01.sql
CREATE OR ALTER PROC SampleProcedure
AS
BEGIN
   INSERT INTO aTable (columnA = 'varcharValue', columnB = 1);
   INSERT exampleTable VALUES ('Hello', 23);
   INSERT INTO exampleTable DEFAULT VALUES;
END

Notice in line 6 of the input code, that there is a reference to a INSERT statement with DEFAULT VALUES, this is currently a not supported statement by SnowConvert and that is why in lines 11 and 12 the EWI is generated.

Recommendations

Last updated