0

I am trying to connect to Redshift cluster ( available ) from Aginity workbench for Redshift. I plugged in all the required credentials which are used in creating the cluster but still I get the below error. Can someone help me with this. Thank you.

enter image description here

Mark B
  • 183,023
  • 24
  • 297
  • 295
Teja
  • 13,214
  • 36
  • 93
  • 155
  • 1
    Is the Redshift cluster publicly accessible? Is the security group open? – Mark B Oct 24 '17 at 16:14
  • No, it is not publicly accessible. – Teja Oct 24 '17 at 16:17
  • Where are you trying to run Aginity from? A Windows server on AWS in your VPC? Or on you local computer? – Mark B Oct 24 '17 at 16:54
  • I have aginity for redshift installed on windows 7( my local computer ) – Teja Oct 24 '17 at 16:58
  • 1
    Then you will need to enable the "publicly accessible" flag on the Redshift cluster. As it is only resources inside your VPC can access the cluster right now. Also you will need to add your local IP address to the security group assigned to the Redshift cluster. – Mark B Oct 24 '17 at 17:00
  • There are bunch of Elastic IPs in the drop down. Which one do I need to select from them? – Teja Oct 24 '17 at 17:02
  • 1
    I have no idea what you are talking about. How are Elastic IPs related to this at all? Are you talking about the IP address you should enter in the security group? That should be your local computer's IP address, not an Elastic IP. – Mark B Oct 24 '17 at 17:05
  • In Configure Networking options there is an option called Choose a Public IP address where yes or no needs to be selected. If I select yes then its asking me to pick a Elastic IP from a bunch of IPs in the drop down. – Teja Oct 24 '17 at 17:11
  • 2
    You can't assign Elastic IPs to Redshift, unless they just released that feature today without announcing it. So I have no clue what you are talking about. – Mark B Oct 24 '17 at 17:30
  • can you access your redshift cluster from elsewhere or from another product/tool? – Jon Scott Oct 25 '17 at 08:43
  • No.. still no luck :( – Teja Oct 26 '17 at 15:58
  • @Mark B - I'm having the same issue as Teja. I have set the database as Publicly Accessible. How do I "add (my) local IP address to the security group assigned to the Redshift cluster" ? (Or alternatively, how do I run Aginity from a 'Windows server on AWS in your VPC"? – James Mar 22 '18 at 22:39

0 Answers0