Create Connection Error for Aurora PostgreSQL and dbt Cloud

[nikohunt]

The problem I’m having

I have configured security groups/firewalls correctly in AWS using the relevant IP addresses for the trial I am on, and can indeed successfully connect to a Redshift Serverless workgroup. However, I cannot connect to Aurora PostgreSQL instance on AWS. I get the error message as follows:

Something went wrong. Please address the issues below and try again.
Create Connection Error: Could not make sense of [endpoint-details-here].eu-west-1.rds.amazonaws.com and/or network.

The context of why I’m trying to do this

I’m trying to do this as the first step of setting up a dbt project.

What I’ve already tried

I have already tried making the Aurora workgroup publicly accessible, in a public subnet, and allowed the relevant IP addresses. I have also double checked all connection parameters including username and password.

Any advice would be appreciated, thank you!

[a_slack_user]

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.RegionsAndAvailabilityZones.html suggests http://rds.eu-west-1.amazonaws.com|rds.eu-west-1.amazonaws.com , are the parts of your connection URL flipped?

_{Note: @Jennifer Berk originally posted this reply in Slack. It might not have transferred perfectly.}

[nikohunt]

Thanks for the fast response!

I flipped the elements of the Hostname, as suggested by the link, and I get the same error.

I then tried the Hostnames:

jabber.jabber.eu-west-1.rds.amazonaws.com
and
jabber.jabber.rds.eu-west-1.amazonaws.com

And got the same error messages as the supposedly valid Hostname.

I know this hostname works though (the original hostname), since I can connect from Power BI and Tableau.

[nikohunt]

Oh for crying out loud - someone changed the endpoint name - we’re clickopsing a PoC so these things can happen.

Your suggestion made me look much harder at the endpoint name, though, thanks so much!

Case closed.

[a_slack_user]

Good catch!

_{Note: @Jennifer Berk originally posted this reply in Slack. It might not have transferred perfectly.}