Use the options in this tab to define how the data is loaded using the Redshift COPY command:
| Option | Description |
|---|---|
| Database connection | Select your database connection from a list of existing Redshift connections. If you do not have an existing connection, click New. If you need to modify an existing connection, click Edit. An exclamation mark appears in the title of the Output tab if a connection cannot be established to the selected database. In this case, click Edit to modify your connection settings. You must specify your IAM-role based access or credentials in your database connection for Redshift. Within the Database Connection dialog box, select either Role or Credentials. For your S3 role, specify the IAM-role in Role Name. For your S3 credentials, specify the Access Key ID and Secret Access Key. |
| Schema | Select the schema to use for the bulk load. |
| Table name | Select the name of the table to bulk load. You can only load one table at a time. You will need to use multiple Bulk load into Amazon Redshift entries or loop over a single entry to load multiple tables. |
| Columns | Preview columns within your selected Table name. |