MSCEWI1040

Statement Not Supported.

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]​

MSCEWI1039

MSCEWI1041

Last modified 3mo ago