These instructions describe how to setup connection to an Amazon Redshift database, using an internet-facing Network Load Balancer (NLB).
Prerequisites
- A VPC with an internet gateway attached
- A public subnet in this VPC that allows inbound TCP traffic on port 5439 and all outbound TCP traffic (via a security group)
- Redshift cluster with RA3 node types and Cluster relocation or Multi-AZ must be enabled.
Steps
- Create a new VPC endpoint from Redshift Console → Clusters → your cluster → Properties → Redshift-managed VPC endpoints.
- Choose the VPC and subnet created in prerequisites. Wait for the endpoint to be created. Once it is created, copy the private IP on the endpoint
- Create a new EC2 Target Group, Choose IP Address type, TCP as the protocol and 5439 as the port. Choose the above VPC as well.
- In the next step of target group creation, paste the IP from the endpoint, Click the "Include as pending below" button under the Port section
- Create the target group
- Create a network load balancer from under EC2 -> Load Balancer, select Internet facing. Under Network mapping choose the above VPC and subnet.
- Choose the security group created in prerequisites
- Change protocol to TCP and port to 5439
- Select the target group created in the previous step in "Forward to target group" config.
- Review & create the NLB.
Configuring the Syncari Redshift Synapse
Once the NLB is created you can use the DNS name shown on the details panel as the "Cluster name" on the synapse configuration. Reference the Redshift Setup article for details.