Cannot Create Glue Connection

Question

I setup a JDBC connection in AWS Glue to an RDS database. When I test the connection from AWS Console, I get an error: Could not find S3 endpoint or NAT gateway for subnetId xxxx. Why does AWS Glue connection to RDS need S3 VPC Endpoint?

The RDS instance has a security group that is completely open to all IP addresses.

Answer 1

I don't know exactly what it is needed for, but my Glue connection to RDS started working only when I had created S3 endpoint.

1. VPC → Endpoints
2. Create S3 endpoint
   • Service category: AWS services
   • Service name: com.amazonaws.eu-central-1.s3
   • VPC: choose one that your RDS is associated with
   • Route tables: choose one that contain subnets for VPC