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]
Last updated