Statement Not Supported.
This warning is added when there is a statement that is not supported in SnowFlake.
In the following example, the
gocommand 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 the
gocommand check here.
CREATE OR ALTER VIEW DateTableView1
SELECT * FROM DateTable;
OR REPLACE VIEW PUBLIC.DateTableView1
SELECT * FROM PUBLIC.DateTable;
-- ** MSC-WARNING - MSCEWI1040 - THE STATEMENT IS NOT SUPPORTED IN SNOWFLAKE **
- Review the original functionality of the statement and check if it is actually needed for your specific needs in Snowflake.