Connection Refused to Specific Redshift

[gustavocarnaval]

We have an AWS Redshift instance that is been used with Looker Studio for a while, but a few weeks ago the connection stop to work and we are getting this error:

We noticed that other Redshift instance keep working as usual but this one not. Any thoughts about what can be done? Tnx

[gustavocarnaval · Accepted solution]

Solved by using "jdbc:postgresql://" instead of "jdbc:redshift://" on the connection url. Really strange because we have another redshift instance that works fine with "jdbc:redshift://". 🤔

[gojoe]

Are you using redshift's or PG's jdbc? Redshift's supports both prefixes while PG's only supports PG prefix.