Amazon Athena Federated Query Dashboard

LIVE AWS DATA

Retail Sales Intelligence · Cross-Source Join across S3 & RDS MySQL

Checking API...

Key Performance Indicators

· GET /summary
Last Update: Just now
Total Sales
--
Gross Sales Revenue S3 × RDS
Total Orders
--
Historical Order Count S3 (sales.csv)
Customers
--
Matched Relational Accounts RDS MySQL
Average Order Value
--
Total Sales / Total Orders AOV

Interactive Athena Federated Query

Real-Time Cross-Source JOIN

Select or enter a customer to execute a live distributed SQL query. Amazon Athena joins transactional sales records in Amazon S3 with customer records in Amazon RDS MySQL in real time.

Ready to execute query

Rahul Kumar

C001 Athena Federated Result
City: Hyderabad (RDS MySQL) · Orders: 2 (Amazon S3)
Total Federated Sales: ₹5,700

Matching Sales Transactions from Amazon S3

s.customer_id = c.customer_id
Order ID Customer ID Product ID Order Date (S3) Amount
1001 C001 P001 2026-09-01 ₹2,500
1003 C001 P003 2026-09-02 ₹3,200

S3 — Sales Data

retail_analytics.sales (sales.csv)
Amazon S3
Order ID Customer ID Product ID Order Date Amount
1001C001P0012026-09-01₹2,500
1002C002P0022026-09-01₹1,800
1003C001P0032026-09-02₹3,200
1004C003P0012026-09-02₹1,500
1005C002P0032026-09-03₹2,800

Stored in Amazon S3 CSV bucket without relational indexing.

RDS MySQL — Customer Data

rds_mysql_catalog.retaildb.customers
Amazon RDS
Customer ID Customer Name City (Location)
C001Rahul KumarHyderabad
C002Arjun ReddyVijayawada
C003Priya SharmaChennai

Stored in Amazon RDS MySQL transactional relational database.

Customer Sales Leaderboard

0 records

Aggregated Athena Federated JOIN results · Click any row to query

Rank Customer City Orders Total Sales
Loading customer analytics from AWS...

Sales by City

GET /city-sales
Loading city analytics...

Sales by Date

GET /date-sales
Loading date analytics...

DATA SOURCES

· Heterogeneous Cloud Architecture
AMAZON S3
Historical Sales Data

CSV object containing historical order transactions

sales.csv
AMAZON RDS MYSQL
Customer Database

Relational database storing live customer master records

retaildb.customers
AMAZON ATHENA
Federated Query Engine

Executes distributed cross-source SQL queries in place

Trino Engine
AWS LAMBDA
Query Backend

Serverless query orchestration with AWS SDK v3

Node.js API
API GATEWAY
Application API

Secure HTTP REST endpoints with CORS enabled

HTTP API v2

System Architecture & Execution Pipeline

End-to-end distributed data processing flow without moving data

Zero-ETL Architecture
Client Layer
Frontend Dashboard
HTML + JS + Tailwind
API Layer
Amazon API Gateway
HTTP API (CORS Enabled)
Compute Layer
AWS Lambda
Node.js Query Dispatcher
Amazon Athena Query Engine
Federated Cross-Source SQL JOIN
Amazon S3 (Sales Data)
retail_analytics.sales (sales.csv)
Amazon RDS MySQL (Customer Data)
rds_mysql_catalog.retaildb.customers
↓ FEDERATED JOIN ↓ → LIVE ANALYTICS

Project Concept & Architecture

Historical sales data is stored in Amazon S3, while customer information is stored in Amazon RDS MySQL. Amazon Athena uses federated querying to combine these datasets without first moving them into a single database. AWS Lambda and API Gateway expose the analytics to the web dashboard.

Live System Status

● Operational
Backend
AWS Lambda
● Operational
Athena Federation
Trino Engine
● Operational
API Gateway
HTTP API v2
● Connected
Data Sources
S3 + RDS MySQL
✓ Synchronized

Federated SQL Query

Real query executed by Amazon Athena across S3 and RDS catalogs

SELECT
    c.customer_name,
    c.city,
    COUNT(s.order_id) AS order_count,
    SUM(s.amount) AS total_amount
FROM retail_analytics.sales s
JOIN rds_mysql_catalog.retaildb.customers c
    ON s.customer_id = c.customer_id
GROUP BY
    c.customer_name,
    c.city
ORDER BY total_amount DESC;

This query joins sales data stored in Amazon S3 with customer data stored in Amazon RDS using Amazon Athena Federated Query.