Rewrite External Table RS
  • Dark

Rewrite External Table RS

  • Dark

This article is specific to the following platforms - Redshift.

Rewrite External Table

The Rewrite External Table component uses SQL provided by the input connection and writes the results out to a new external table.

Note: Running this component will overwrite any existing data on the chosen S3 location, and performing this action on the same location from which the source data is referenced is typically not recommended. The Matillion ETL instance must have access to the chosen S3 bucket and location.

External tables are part of Amazon Redshift Spectrum, and may not be available in all regions. For a list of supported regions, read the Amazon documentation.

For full information on working with external tables, see the official documentation here.


Property Setting Description
Name Text A human-readable name for the component.
Schema Select Select the table schema. Note that an external schema must be used. For more information on using multiple schemas, read Schema Support.
Target Table Text The name of the newly created external table.
Location Select Select the file target location, including S3 bucket path. The Matillion ETL instance must have access to these data (typically, access is granted according to the instance's AWS credentials or if the bucket is public). A directory named after the target table will be created at this location and then populated with files.
Partition Select Multiple (Optional) Select source columns to be partitions when writing data. Chosen columns will be queried for distinct values and partitioned file directories will be created (if they don't exist) for those values.
File Format Select Select the file format. The default setting is Delimited.

What's Next