Cannot Create Glue Connection

2
votes

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.

1
amazon-web-servicesaws-glueaws-glue-data-catalog

1 Answers

7
votes

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