Intro on Athena from Cantrill’s SAA-C03
Amazon Athena 101
Intro to Amazon Athena
Ref: https://www.udemy.com/course/aws-certified-machine-learning-engineer-associate-mla-c01/learn/lecture/46730209
-
🔧 Serverless, interactive SQL-like query service
-
Presto under the hood
-
Supported compression formats: Snappy, Zlib, LZO, Gzip
-
Integrations
- Notebooks: Jupyter, Apache Zeppelin, RStudio
- Visualization tools
- QuickSight
- Other tools integration via ODBC/JDBC
-
Many formats supported:
| Athena-supported data format |
Human readable? |
Columnar? |
Splittable? |
| CSV, TSV |
Yes |
No |
No |
| JSON |
Yes |
No |
No |
| ORC |
No |
Yes |
Yes |
| Parquet |
No |
Yes |
Yes |
| Avro |
No |
No |
Yes |
Athena Features
Ref: https://www.udemy.com/course/aws-certified-machine-learning-engineer-associate-mla-c01/learn/lecture/46730253
Athena Workgroups
- 🔧 Organize or segregate Athena usage
- e.g. users/teams/apps/workloads…
- Each workgroup can have its own:
- Query history
- Allows tracking costs per workgroup
- Data scan limits
- Each workgroup can have a different limit on how much data it can scan in a query
- IAM policies
- Athena query access control
- Encryption settings
- CW/SNS settings (for EDA)
Cost Model