Connect to Amazon Redshift

Connect to Amazon Redshift via Data Loader and use it as your destination for batch-loading a pipeline.

Prerequisites

An active Amazon Redshift instance. Instructions for creating an Amazon Redshift destination are outside the scope of this tutorial. Our instructions assume that you have an instance running. For help getting started with Amazon Redshift, read Getting started with Amazon Redshift.
Permissions in Amazon Web Services (AWS) that let you:
- Create/manage security groups.
- View database details, which are required for retrieving the database's connection details.
Super user privileges, or privileges that let you to create users and grant privileges. These privileges are required to create a database user for batch data loading.

Read Set up Amazon Redshift for more information.

Select an existing AWS cloud credential, or click +Add AWS cloud credential to make a new one.

Property	Description
AWS credential label	A unique, descriptive name for your new AWS credential.
Access Key ID	An AWS access key. Read Understanding and getting your AWS credentials for more information.
Secret Access Key	An AWS secret access key. Read Understanding and getting your AWS credentials for more information.

Click Test and save to continue.

Property	Description
AWS cloud credentials	Select or create the required credentials from the dropdown list.
Destination label	A unique, descriptive label for your destination.
Endpoint	Your AWS endpoint. Use the following format: `jdbc:redshift://endpoint:port/database`. Read Getting the JDBC URL for more information.
Port	The database port. The default is `5439`.
Username	Your AWS login username.
Password	A managed entry representing your AWS login password. Choose an existing password from the dropdown menu or click Manage and then click Add new password to configure a new managed password entry. Give the password a label, which is what you can see in the password dropdown menu, and then input the value of the password. Read Manage Passwords to learn more.
Advanced settings	Additional JDBC parameters or connection settings. Click Advanced settings and then choose a parameter from the dropdown menu and enter a value for the parameter. Click Add parameter for each extra parameter you want to add.

Click Test and continue to test your settings and move forward. You can't continue if the test fails for any reason.

Property	Description
Default database	Select an AWS database. The dropdown list is populated according to the account you logged in with.
Default Schema	Select a schema.

Click Save destination to complete the process.