Athena

Security Specialty

Solution Architect Associate

Interactive query service which allows you to analyze and query data located in S3 using standard SQL
Serverless, nothing to provision. If you see questions on serverless SQL, it’s likely Athena
No need to setup ETL processes to query this data
Supports CSV, JSON, Apache Parque, etc.
You pay per query, and per Terrabyte of data scanned
Can be used to do things like:
- Querying log files stored in S3
- Generate business reports from data located in S3
- Analyze cost and usage reports
- Can run queries on things like click stream data from your website
To start, you need to create a “database” using the “create database " to start
You then need to create tables and populate them into the database