📊Amazon Athena
Also known as Athena, AWS Athena
An AWS service that runs SQL on files in S3. You pay for the data each query reads.
Think of it like
It is like a library where you pay for each page you read. You never pay for the shelves.
Example
Lucy keeps a year of web logs in S3. One Athena query reads 200 GB and costs about $1, at $5 per terabyte read.
Why it matters
Teams can query files in a lake without running a warehouse. For a few questions a week, it costs very little.
Definition
Example code
sql
SELECT status, COUNT(*) AS hits
FROM web_logs
WHERE day = '2026-03-02'
GROUP BY status;Common mistake
Key takeaways
- 1No servers. AWS runs the engine for you.
- 2Pay per scan. The bill follows the data read.
- 3Files stay put. The data stays in S3 as files.