Athena

  • [[Athena]] is a interactive query service for Amazon [[S3]].
  • Analyze [[S3]] data using SQL
    • This allows you to directly query data in your S3 bucket without loading it into a database.
  • Pay per query and per TB scan
  • Considered serverless
  • No need to setup ETL processes.
  • Athena Use Cases
    • Query Log files - e.g [[ELB]] logs, [[S3]] access logs
    • Cost analysis - AWS cost and usage reports.
    • Generate business reports on data stored in [[S3]]
    • Run queries on Analyse click stream
  • Using Athena and [[Glue]] Together