Question

can't connect to redshift - a sporadic issue that started yesterday

  • 9 August 2021
  • 2 replies
  • 30 views

We are seeing a sporadic issue b/w looker and redshift. This was started yesterday. Our Redshift connection uses SSL. Any hunches on this?


2 replies

Userlevel 4
Badge

Hi @Ritesh Kuchukulla

 

Generally, I would suggest reaching out to our support team to discuss this in more detail, but if you go to admin → connections and test the connection settings, do all the tests pass? If they do not pass, would you be able to share the error message, please? 

 

Thanks,

Eric

this is the error - 

Cannot connect: connection refused: Java::OrgPostgresqlUtil::PSQLException: 

Currently we are whitelisting - 

CidrIp: 35.186.176.0/32

CidrIp: 34.86.189.113/32

CidrIp: 34.86.136.190/32

CidrIp: 35.245.211.109/32

CidrIp: 35.221.3.163/32

CidrIp: 35.194.74.185/32

CidrIp: 34.86.52.188/32

CidrIp: 35.245.82.73/32

CidrIp: 34.86.118.239/32

CidrIp: 35.245.177.112/32

CidrIp: 34.86.214.226/32

CidrIp: 35.168.173.238/32

CidrIp: 54.162.175.244/32

CidrIp: 54.80.5.17/32

CidrIp: 52.44.187.22/32

CidrIp: 18.213.96.40/32

CidrIp: 23.22.133.206/32

CidrIp: 54.208.10.167/32

CidrIp: 54.209.116.191/32

CidrIp: 52.1.5.228/32

CidrIp: 52.1.157.156/32

CidrIp: 54.83.113.5/32

Are there any new Ip’s to whitelist ?

Reply