The use of foreign tables is not supported in Snowflake.
Foreign tables 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.
SELECT cust_id, income, age FROM
FOREIGN TABLE (SELECT cust_id, income, age FROM twm_customer)@hadoop1 T1;
-- ** 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
- Instead of external tables in Teradata, you can use Snowflake external tables. External tables reference data files located in a cloud storage (Amazon S3, Google Cloud Storage, or Microsoft Azure) data lake. This enables querying data stored in files in a data lake as if it were inside a database. External tables can access data stored in any format supported by COPY INTO <table> statements.
- Another alternative is Snowflake's Iceberg tables. So, you can think of Iceberg tables as tables that use open formats and customer-supplied cloud storage. This data is stored in Parquet files.
- Finally there are the standard Snowflake tables which can be an option to cover the functionality of foreign tables in Teradata
- For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.