SnowflakeDocumentation Home

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]

PreviousMSCEWI3003NextMSCEWI3005

Last updated