External Table Reference

Description

An external table resides in a text-based, delimited or non-delimited file outside of a database. An external-table-reference specifies the name of the file that contains an external table.

Click here to navigate to the IBM DB2 docs page for this syntax.

External Table Reference is not supported in Snowflake. The output query can be malformed

Grammar Syntax

Sample Source Patterns

IBM DB2

Code 1

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

Snowflake

Code 1

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)

Related EWIs

1. MSCEWI5014: THE USE OF EXTERNAL TABLE REFERENCES IS NOT SUPPORTED IN SNOWFLAKE