Testing Professor
Testing ProfessorMulti-Cloud Guidebook · AWS
All services

Analytics

Amazon Athena

Serverless interactive SQL on S3 data.

Official docs

Overview

Athena lets you query data in S3 with standard SQL using Presto/Trino, paying only per TB scanned.

When to use it

  • Ad-hoc analytics on logs/JSON/Parquet in S3
  • BI on data-lake without warehousing

Setup

  1. Set the query result location (S3 bucket).
  2. Create tables via Glue Catalog (or DDL).
  3. Use partitions + Parquet to slash cost.

How to use

Query
SELECT status, count(*) FROM test_runs WHERE dt >= date '2025-01-01' GROUP BY 1;

QA use cases

  • Analyze CloudFront / ALB access logs to confirm load test traffic patterns and error rates.