Answer
Yes, Athena Federated Query lets you run SQL queries against data sources beyond S3, including relational databases, DynamoDB, and other systems, by using data source connectors, which means you can join data sitting in S3 with data living in an operational database without needing to first copy everything into one place.
SELECT s.customer_id, d.order_total FROM s3_customers s JOIN dynamo_orders d ON s.customer_id = d.customer_id;Real-world example A retail company joins historical order data stored in S3 with live inventory data stored in DynamoDB using Athena Federated Query, producing a combined report without building a separate data pipeline.