How To Use Bastion Host To Ssh To Redshift

I have been trying to figure out how to connect to Amazon Redshift clusters when they are private rather than publicly accessible. I am trying to securely move data from our curre

Solution 1:

The Bastion will simply be used to forward requests from your own computer to Amazon Redshift. You do not need to install any software (eg psql) on the Bastion.

Assuming that you can successfully use PuTTY to login to the Bastion, change this configuration in PuTTY:

• Go to the Tunnels configuration page
• Source port: 5439
• Destination: The full DNS name of your Redshift cluster, followed by :5439
• Click Add
• Save your PuTTY settings

Here's a picture from Connecting to a Redshift Cluster with a Private IP:

This configuration says: "Redirect local port 5439 through the SSH connection to the Bastion server. From there, have the Bastion send the traffic to REDSHIFT-DNS:5439."

Thus, the Bastion just acts like a Jump Box, forwarding your traffic and not actually running anything else.

You can change the local source port to whatever you like, so you can have multiple tunnels on the same SSH connection.