An Engineer’s Guide to:
Connect Athena to RDS PostgreSQL.
Step-by-step: connect the data source through the AWS console.
Intro.
This document assumes that you already have a PostgreSQL RDS instance (SQL and other engines are very similar) and have set up all the required networking capabilities, and have gathered the following connection credentials. If not, please follow this guide to set up your RDS using CDK or this or this guide to set up through the console.
Please also make sure there are some tables, schemas, views, and sample data in your database. I’m planning to publish an easy-to-follow guide to do this; please make sure to subscribe to be notified!
Needed information:
- Database host
- Database Port
- DB username and password
- RDS security group ( accessible from Lambda )
- RDS subnet ( Accessible from Lambda )