Skip to content

External Table Output

Writes new external table data with a column mapping of the user's choice, appending existing external tables. To output a new external table rather than appending, use the Rewrite External Table component.

External tables are part of Amazon Redshift Spectrum and may not be available in all regions. For a list of supported regions, read Querying external data using Amazon Redshift Spectrum.

For information about working with external tables, read Creating external tables for Redshift Spectrum.

Properties

Name = string

A human-readable name for the component.

Schema = drop-down

Select the table schema. The special value, [Environment Default], will use the schema defined in the environment. For more information on using multiple schemas, read Schemas.

Target Table Name = drop-down

The table to append data to.

Column Mapping = column editor

All input fields are available, and can be added multiple times to create copies of a field.

  • Source Column: All input fields are available, and can be added multiple times to create copies of a field.
  • Target Column: The output field name. By default, this is the same as the input. Just overwrite your preferred names.

S3 Object Prefix = drop-down

The file name to write data to. These files are stored at the S3 bucket location given when creating an external table. If this field is left blank, an automatically generated UUID will be used as the prefix.

Snowflake Delta Lake on Databricks Amazon Redshift Google BigQuery Azure Synapse Analytics
❌ ❌ ✅ ❌ ❌