External Schemas and Tables

Overview

External tables are used to query data stored outside your chosen cloud data warehouse. The table's metadata, including the table schema, is stored in your data warehouse, but the data itself is located externally.

Useful Links

This article displays links explaining how to use external tables in Matillion ETL for your chosen cloud data warehouse, as well as useful, supported, and corresponding website information.

Matillion ETL Documentation:

• Create External Table for Snowflake
• Create External Table for Redshift
• Create External Table for Google Big Query
• Create External Table for Azure Synapse

External Websites:

• Working with External Tables for Snowflake
• Creating external tables for Redshift Spectrum
• REST Resource: tables for Google Big Query
• Using external tables with Synapse SQL