How to connect Redshift to Adriel

Detailed instructions to help you set up the data source for Redshift

Lastly modified on: Thu, 20th June, 2024 at 03:48 PM

Prerequisites

• Redshift account

Instructions

Step 1: Finding Redshift Host name and Database

1. Login to your Amazon console. 
2. Move to Amazon Redshift > Clusters > Cluster name > [Properties] tab > Connection details.
3. Copy from the host: to .com. That is the name of the host. 
   EX) host:default-workgroup.<numbers>.ap-northeast-2.redshift-serverless.amazonaws.com
4. Copy the very last part of the host connection details. Bold letters part of the example below is the database. 
   EX) host:default-workgroup.<numbers>.ap-northeast-2.redshift-serverless.amazonaws.com:5439/dev

Step 2: Connecting Redshift to Adriel

1. Move to Adriel's Connections page.
2. Type “Redshift” into the search bar.
3. Fill in the 6 required fields accordingly to the account that you want to connect to Adriel. 
   - Name: Fill in any identifiable name. 
   - Host: Host name of your Amazon Redshift instance. Fill in the host name found at Step 1. 
   - Port: Default port of Redshift is 5439
   - Database: Database that data will be fetched. Fill in the database found at Step 1. 
   - User: Username that will give access to Adriel.
   - Password: password for the above user account.
4. Choose the table that you want to connect to. Multiple choices are possible. 
5. Click the “Submit” button below to complete the data connection.
   
   If your database is hosted behind a firewall, whitelist the following IP address: 52.79.160.224 
    
   It can take up to one working day for your data to arrive.