MSCEWI1040

Statement Not Supported.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

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 go command from SQL Server is used. This is actually not a Transact-SQL statement; it is a command recognized by the sqlcmd and osql utilities and SQL Server Management Studio Code editor. Either way, it provides functionality not available in SnowFlake, for more info about thegocommand check here.

Input Code:

CREATE OR ALTER VIEW DateTableView1
AS
SELECT * FROM DateTable;

GO

Source Code:

CREATE
OR REPLACE VIEW PUBLIC.DateTableView1
AS
SELECT * FROM PUBLIC.DateTable;

-- ** MSC-WARNING - MSCEWI1040 - THE STATEMENT IS NOT SUPPORTED IN SNOWFLAKE **
--GO

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]