MSCEWI5014

THE USE OF EXTERNAL TABLE REFERENCES IS NOT SUPPORTED IN SNOWFLAKE

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 external tables in the Select statement. For this reason, the result query could not be valid

Code Example

DB2

SELECT
   *
FROM
   EXTERNAL SOMENAME AS T1 LIKE TABLE2 USING(COMPRESS NO)

Snowflake

SELECT
   *
FROM
-- ** MSC-ERROR - MSCEWI5014 - THE USE OF EXTERNAL TABLE REFERENCES IS NOT SUPPORTED IN SNOWFLAKE **
--   EXTERNAL SOMENAME AS T1 LIKE TABLE2 USING(COMPRESS NO)

Recommendations

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