Amazon Athena, a serverless interactive query service, allows users to analyze data stored in S3 using standard SQL. One of its most powerful features is federated querying, which lets you extend Athena’s capabilities beyond S3 and into relational databases like RDS PostgreSQL. This podcast will walk you through implementing federated queries between Athena and an RDS PostgreSQL instance, enabling seamless integration and enhanced data analytics capabilities.
https://businesscompassllc.com/seamlessly-query-rds-postgresql-with-amazon-athena-a-step-by-step-guide/