MSCEWI5008

DELETE FROM SELECT STATEMENT IS NOT SUPPORTED.

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 select queries in the From clause of a Delete statement. If the Delete statement is migrated partially we get an incomplete statement as the From clause will be empty. For this reason, the complete Delete statement will be commented out with this EWI

Code example

DB2

Select Query

DELETE FROM (
SELECT * FROM table1
)

Snowflake

Select Query

-- ** MSC-ERROR - MSCEWI5008 - DELETE FROM SELECT STATEMENT IS NOT SUPPORTED. **
--DELETE FROM (
--SELECT * FROM table1
--)

Recommendations

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