What is AWS Athena?

Athena is a serverless interactive query system offered by AWS. It makes easier to analyze large amounts of data stored in S3.

Athena in a nutshell is:

  • Serverless Interactive query platform
  • Works on the data stored in S3
  • Uses standard SQL for querying data
  • Supports variety of formats
    • CSV
    • JSON
    • Avro
    • ORC (columnar)
    • Parquet (columnar)
  • Only pay for querying the data