Rewrite External Table RS
    • Dark
      Light

    Rewrite External Table RS

    • Dark
      Light

    Article Summary

    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

    PropertySettingDescription
    NameTextA human-readable name for the component.
    SchemaSelectSelect the table schema. Note that an external schema must be used. For more information on using multiple schemas, read Schema Support.
    Target TableTextThe name of the newly created external table.
    LocationSelectSelect 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.
    PartitionSelect 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 FormatSelectSelect the file format. The default setting is Delimited.