Issue to connect to Postgres RDS using AWS Glue

Hello Andrey,

error description is not that specific. You could try some ways to resolve issue such as-

• Check if RDS security group allows ingress traffic on the database port (e.g 3306) from the Glue VPC security group. Glue needs to connect to RDS from there.

• Verify the RDS endpoint, database name, username, and password are all correct in the Glue connection. Test the connection parameters directly from a client like SQL Workbench.

• Recheck networking/routing between the Glue VPC, RDS subnet groups. Ensure there is a VPC peering connection or routes set up.

• increase the timeout for the Glue connection test. The default can sometimes be too short with networking delays. Try say 3 -4 mins.

• Check CloudWatch Logs for specific log failures from Glue during the connection test. Details could help point to root causes.

• Try creating a simpler Glue table/database pointing to RDS to test first. this will rule out other moving parts such as crawlers etc.

• Check for service limits in Glue and Rds

Hope this helps, pls let me know if works out. Thanks

Ensure the glue connection is on a private subnet with either a route to a NAT gateway or you have setup the glue vpc endpoint.

This may resolve your issue.