Supply Chain & Retail Solutions user guide

Connecting a Redshift data warehouse (public connectivity)

Prerequisites​

• Access to Peak with permissions to configure Data Bridge.
• Your Redshift cluster is publicly accessible.
• You have the Redshift host URL, port, database name, and credentials.
• A data lake is already configured in Peak in the same region as your Redshift cluster.

Steps​

1. In Peak, open Manage and select Data Bridge.

2. Select Add data warehouse.

3. Enter a unique name for the connection and select Amazon Redshift.

   • The name must be unique to your Peak organization.
   • Use only alphanumeric characters and underscores. No spaces or other special characters.
   • Minimum 3 characters, maximum 40 characters.
   • Must start and end with an alphanumeric character.
   • The name cannot be changed after the connection has been set up.

4. Select the region where your Redshift cluster is hosted. Ensure the region complies with your data localization requirements.

   Supported regions: Ireland (eu-west-1), London (eu-west-2), Mumbai (ap-south-1), North California (us-west-1), North Virginia (us-east-1).

5. Select Public connectivity.

6. Copy the Peak IP addresses displayed in the configuration step.

7. In AWS, add the Peak IP addresses to your Redshift cluster's security group inbound rules:

   • Open the Redshift console and select your cluster.
   • On the Properties tab, scroll to Network and security and open the VPC security group.
   • On the Inbound tab, select Edit and add a new rule with the following values:
     • Type: Custom TCP
     • Protocol: TCP
     • Port range: the port number of your Redshift cluster (for example, 5439)
     • Source: Custom — enter the Peak IP addresses
   • Save the rule.

8. In Peak, confirm that IP whitelisting is complete by selecting the confirmation checkbox.

9. Select Next to proceed to the database step.

10. Enter the database credentials. See Credential fields.

11. Select Test to validate the connection.

12. In the Data lake step, select the data lake connection to link.

13. Set up the Redshift IAM role for data lake access. See Configuring the Redshift IAM role.

14. Review the configuration and select Finish.

Credential fields​

Configuring the Redshift IAM role​

1. In Peak, copy the Redshift IAM role policy from the Data lake step.
2. In the AWS IAM console, go to Access management > Policies and create a new policy. Paste the copied JSON on the JSON tab, then save the policy.
3. In Access management > Roles, select the role attached to your Redshift cluster.
4. Select Add permissions > Attach policies and attach the policy you just created.
5. Ensure the AmazonRedshiftAllCommandsFullAccess managed policy is also attached to this role.
6. In Peak, copy the Trusted entity policy from the Data lake step.
7. In the same IAM role, select Edit trust relationship, paste the copied JSON, and save.
8. Copy the IAM role ARN from the role's Summary section.
9. Paste the role ARN into the IAM role ARN field in Peak.

Result​