MSCEWI5007

QUERY AS INSERT TARGET NAME 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 insert target namestatement. For this reason, the complete Delete statement will be commented out with this EWI

Code example

DB2

Query

INSERT INTO (SELECT * FROM SOMEOTHERTABLE) VALUES (DEFAULT);

Snowflake

Query

-- ** MSC-ERROR - MSCEWI5007 - QUERY AS INSERT TARGET NAME IS NOT SUPPORTED **
--INSERT INTO (SELECT * FROM SOMEOTHERTABLE) VALUES (DEFAULT)

Recommendations

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