MSCEWI2076

The use of foreign tables is not supported in Snowflake.

triangle-exclamation

Severity

Medium

Description

Foreign tablesarrow-up-right enable access to data in external object storage, such as semi-structured and unstructured data in Amazon S3, Azure Blob storage, and Google Cloud Storage. This syntax is not supported in Snowflake. However, there are other alternatives in Snowflake that can be used instead, such as external tables, iceberg tables, and standard tables.

Example code

Input code:

SELECT cust_id, income, age FROM 
FOREIGN TABLE (SELECT cust_id, income, age FROM twm_customer)@hadoop1 T1;

Output code:

SELECT
cust_id,
income,
age FROM
-- ** MSC-ERROR - MSCEWI2076 - THE USE OF FOREIGN TABLES IS NOT SUPPORTED IN SNOWFLAKE. **
-- FOREIGN TABLE (SELECT cust_id, income, age FROM twm_customer)@hadoop1 T1
                                                                         ;

Recommendations

Last updated