Athena
| Owner | |
|---|---|
| Verification | |
| Tags | |
| Last edited time |
Query and analyze SQL data that is hosted in S3 without moving it
Pay per data processed (CSV,JSON,ORC) , create dashboards with QuickSight
Used to analyze logs (VPC,ELB,Trail)
📢
to improve performance: query less data, use ORC (use glue to convert data), can compress data for smaller retrievals, can partition the data in S3
Federated Query - can query data from other sources using Lambda and Data source connectors (CloudWatch logs) - data is stored in S3