MSCEWI3004

The used syntax in select is not supported in Snowflake.

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

Severity

High

Description

This error happens when a clause in a select is not supported in Snowflake. The not supported clauses are:

• CONTAINERS

• SUBQUERY RESTRICTION

• HIERARCHIES

• MODIFIED EXTERNAL

• DBLINK

• SHARDS

• PARTITION

• SUBPARTITION

• HIERARCHICAL

Example Code

Input Code:

SELECT * FROM TABLE1 EXTERNAL MODIFY (LOCATION 'file.csv' REJECT LIMIT UNLIMITED);

Output Code:

SELECT * FROM PUBLIC.TABLE1
/*** MSC-ERROR - MSCEWI3004 - THE MODIFIED EXTERNAL SYNTAX IN SELECT NOT SUPPORTED IN SNOWFLAKE ***/;

Recommendations

• No additional user actions are required.

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