# Output tab

![Output tab](https://3411831820-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FAYwCj9fPr1B2pjC11IOQ%2Fuploads%2Fgit-blob-a196346c42e9b7521ade7db24588e96d1f7b2ee1%2FssPDIBulkLoadIntoAmazonReshiftOutputTab.png?alt=media)

Use the options in this tab to define how the data is loaded using the Redshift `COPY` command:

| Option                  | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| ----------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Database connection** | <p>Select your database connection from a list of existing Redshift connections.If you do not have an existing connection, click <strong>New</strong>. If you need to modify an existing connection, click <strong>Edit</strong>.</p><p>An exclamation mark appears in the title of the <strong>Output</strong> tab if a connection cannot be established to the selected database. In this case, click <strong>Edit</strong> to modify your connection settings.</p><p>You must specify your IAM-role based access or credentials in your database connection for Redshift. Within the Database Connection dialog box, select either <strong>Role</strong> or <strong>Credentials</strong>. For your S3 role, specify the IAM-role in <strong>Role Name</strong>. For your S3 credentials, specify the <strong>Access Key ID</strong> and <strong>Secret Access Key</strong>.</p> |
| **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**.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |