This is a deprecated version of the SnowConvert documentation, please visit the official site .
Severity
Medium
Description
Snowflake does not support the use of view name in the delete target name statement. For this reason, the result query could not be valid
Code Example
DB2
CREATE VIEW VIEW1 AS SELECT * FROM T;
DELETE FROM VIEW1
Snowflake
CREATE VIEW PUBLIC.VIEW1
AS SELECT * FROM
PUBLIC.T;
DELETE FROM
-- ** MSC-ERROR - MSCEWI5013 - INVALID NAME AS DELETE TARGET, USE OF VIEW NAME IS NOT SUPPORTED IN SNOWFLAKE **
--PUBLIC.VIEW1