AWS RDS Athena

Querying RDS in a private VPC from Athena.

Create the variables file set the values:

cp config/template.tfvars .auto.tfvars

Create the resources:

terraform init
terraform apply -auto-approve

In Athena, create a PostgreSQL Lambda connector.

The connection string will look something like this:

postgres://jdbc:postgresql://<HOST>:5432/athenadb?user=athena&password=p4ssw0rd