.png){kind=logo}
Rewrite External Table RS
-
DarkLight
Rewrite External Table RS
-
DarkLight
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.
Properties
| 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. |