I. Introduction
- Serverless offering to perform analytics directly against S3 files.
- Uses SQL to query the files, supports JDBC/ODBC driver.
- Charged per query and amount of data scanned.
- Supports CSV, JSON, ORC, Avro and Parquet.
- It's built on top of Presto.
- Used in BI scenarios and log management.
II. Athena for SA
- Operations: serverless so not needed
- Security: IAM + S3 managed
- Reliability: managed service, uses Presto, HA
- Performance: queries scale based on size
- Cost: pay per query and per TB of data scanned