I'd like to query an AWS Redshift cluster from an IDE running on my laptop (IntelliJ). This cluster is only directly accessible from an EC2 instance in our VPC.
That EC2 instance isn't directly accessible from my laptop: it's necessary to
ssh to another server in our datacenter, and then
ssh to an EC2 instance in our VPC in order to run queries on the Reshift cluster via the
psql client. Other users and
cron'd shell scripts also execute commands on this cluster from the same EC2 instance.
I'd like to setup an SSH tunnel from my laptop, through the intermediate server in our datacenter, to the EC2 instance, and ultimately to the Redshift cluster without impacting other users/scripts.
I tried this:
ssh -fNL 5439:localhost:22 host_in_datacenter ssh -fNL 22:localhost:22 ec2_instance ssh -fNL 22:localhost:5439 reshift_host
[08P01] Protocol error. Session setup failed.
... when I try to connect via a client.
Most of the SSH chaining examples to access remote databases I've seen have just one hop to the host running the database, and the final hop ends up on the database host itself.
Is it possible to create an SSH tunnel, without impacting other users, from my laptop to the Redshift cluster? If so, can you see what I'm doing wrong?