MSCEWI5013

INVALID NAME AS DELETE TARGET, USE OF VIEW NAME IS NOT SUPPORTED IN SNOWFLAKE

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

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

Recommendations

• If you need more support, you can email us at [email protected]