Hi, I often work a lot with a Redshift database, to which I have to connect with a Putty tunnel, but it is quite tedious to have to be running Putty every time I want to connect to the DB.
- I have to open a terminal and run the following command from cmd:
putty -P 10044 -noagent -N -L 1000:digitaldev-prd-redshift-cluster-02.cdy6xysljydu.us-east-1.redshift.amazonaws.com:1000
email@example.com -i ni_nestor.xxxxx.ppk
some values of this command are fictitious for privacy.
- Then it opens the following window containing the personal private key in Putty in which I must be entering the tunnel password.
- Then I have to minimize the window and even then I have to make the connection to the DB, or reload it.
I have tried different ways to set the SSH connection configuration from DataGrip itself, and I have not succeeded.
This is one of the configurations I have made, with Attestation Type: Key Pair PuTTy:
and when I run the test, I get the following error:
I have also tried with Authentication Type: "Password, and I get the same error.
I would be very grateful if you could help me to set up this tunnel configuration.