Athena overview¶

• Serverless service to perform analytics directly against AWS S3 files
• Uses [[SQL]] language to query the files
• Has a [[JDBC]] / [[ODBC]] driver
• Charged per query and amount of data scanned
• Supports [[CSV]], [[JSON]], [[ORC]], [[Avro]] and [[Parquet]] (built on [[Presto]])

• Use cases: [[Business intelligence]] / analytics / reporting, analyse & query VPC Flow Logs + Athena, [[ Load Balancer Logs ]], CloudTrail trails etc

• Fully Serverless database with [[SQL]] capabilities

• Used to query data in AWS S3
• Pay per query
• Output results back to AWS S3
• Secured though IAM

Use case: one time SQL queries, Serverless queries on AWS S3, [[log analytics]]