Set up a connection to Amazon Redshift (REST API)

Amazon Redshift is data warehouse product that helps customers to handle large-scale data storage and database migrations.

Set up a connection

This video demonstrates creating an Amazon Redshift connection.

After you start the connection, configure it in the Create connection panel and complete all of the required * authentication settings.

Setting	Instructions
Name your connection *	Enter a clear and distinguishable name. Throughout integrator.io imports and exports, you will have the option to choose this new connection. A unique identifier will prove helpful later when selecting it from a list of the connections in your account.
Region*	Enter your Amazon Redshift account region. For example, if it says Oregon, enter us-west-2.
Access key ID *	Enter your Amazon Redshift access key ID. Multiple layers of protection are in place, including AES 256 encryption, to keep your connection’s access key ID safe. When editing this form later, you must enter this value again; it is stored only for a saved connection. How to retrieve the access key ID
Secret access key *	Enter your Amazon Redshift secret access key. Multiple layers of protection are in place, including AES 256 encryption, to keep your connection’s secret access key safe. When editing this form later, you must enter this value again; it is stored only for a saved connection. How to retrieve the secret access key

Tip: This connector documentation describes only the settings shown for the Simple view. For the corresponding HTTP settings, see custom universal connector documentation.

How to retrieve the access key and secret access key

1. Sign in to your account at aws.amazon.com/console. 
2. Navigate to Services > Security, identity and compliance > Identity and access management (IAM).
3. Under Access management > Users.
4. On the Summary page, click Security credentials. 
5. Click Create access key. The Access key best practices & alternatives page opens.
6. Choose the required option and click Next. The Set description tag page opens.
7. Enter Description.
   
8. Click Create access key.
9. Copy Access key.
10. Copy Secret access key.
11. Click Done.

Additional references

• Amazon Redshift API guide