Amazon Redshift is a data warehouse product that helps customers to handle large-scale data storage and database migrations.
- A. Set up an Amazon Redshift (REST API) connection
- B. Provide required Amazon Redshift (REST API) application details
- C. Edit advanced Amazon Redshift (REST API) settings
- D. Test the connection
Start establishing a connection to Amazon Redshift (REST API) in either of the following ways:
- From the Resources menu, select Connections. Then, click + Create connection at the top right.
– or –
- While working in a new or existing integration, you can add an application to a flow simply by clicking Add source or Add destination.
In the resulting Application list, select Amazon Redshift (REST API).
The Create connection panel opens with required and advanced settings.
At this point, you’re presented with options for providing Amazon Redshift (REST API) authentication.
Region (required): Enter the portion of the amazonaws.com subdomain that corresponds to the region you identified when setting up your Amazon Redshift account.
Access key ID (required): Enter the Access key ID that you generated in your Amazon Redshift account.
Secret access key (required): Enter the secret access key associated with the Access key ID. Multiple layers of protection are in place, including AES 256 encryption, to keep your connection’s Secret access key safe.
- Sign in to your account at aws.amazon.com/console.
- You can see the region at the top right. For example, if it says Oregon, enter
us-west-2for the Region setting in the connection.
- From the Services menu, navigate to Security, identity, & compliance > Identity and access management (IAM). Under Access management, select Users.
- In the users Summary page, click the Security credentials tab.
- If you have an existing Access key ID, you may provide it above, assuming that you already recorded the secret access key. To generate a new access key, click Create access key.
- Copy this app’s Access key ID and Secret access key.
Before continuing, you have the opportunity to provide additional configuration information, if needed, for the Amazon Redshift (REST API) connection.
Once you have configured the Amazon Redshift (REST API) connection, you have a few options for continuing:
- Save – click this button to test the connection, commit the new connection so that it will be available to all integrations for your account
- Save & close – click to test and save the connection and exit the Create connection panel
- Close – click to exit without saving any new changes
- Test connection – click this button to verify that your new connection is free of errors
When you test or save the connection, it is verified before continuing.
The new connection is now successfully added to your account. It will be applied to the current source or destination app if you created it within a flow. Otherwise, you may proceed to register the connection with an integration.