This is a deprecated version of the SnowConvert documentation, please visit the official site .
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)