Data Analysis
Querying data at rest.
| Service | Job | Choose when | Key distinction |
|---|---|---|---|
| Amazon Athena | SQL on S3 | Ad-hoc queries, no infrastructure | Serverless, pay per query scanned |
| Amazon Redshift | Data warehouse | Complex analytics on structured data | Provisioned/serverless clusters, joins at scale |
- Athena (serverless, query S3 in place) vs Redshift (warehouse for heavy, repeated analytics).