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.
Add AWS credentials
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.
Connect to Amazon Redshift
| 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.
Configure destination
| 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.