Amazon Athena

SaaS

Serverless interactive query service that lets teams analyze data stored in Amazon S3 using standard SQL without managing servers.

aws.amazon.com
Amazon Athena homepage screenshot

About Amazon Athena

Amazon Athena is a serverless, interactive analytics service from AWS. It lets users run SQL queries directly against data stored in Amazon S3, so data can be analyzed where it already lives instead of being loaded into a separate warehouse first.

Because Athena is serverless, there is no infrastructure to set up or manage, and queries are written in standard SQL. It is commonly used for log analysis, ad hoc exploration of data lakes and as a query layer for reports and data pipelines. AWS describes it as handling very large datasets.

Athena is a proprietary AWS service and cannot be self-hosted. Pricing is usage based and is described on the service's pricing page.

Key features

  • SQL queries directly on Amazon S3 data
  • Serverless with no infrastructure to manage
  • Interactive ad hoc analysis
  • Works with data lake files
  • Integration with AWS analytics services

Good fit for

  • Ad hoc analysis of data lake files
  • Querying logs stored in S3
Tags
sql
serverless
aws
data-lake
analytics
s3
query-engine

Amazon Athena: questions and answers

What is Amazon Athena used for?
Amazon Athena is a serverless interactive query service that lets teams analyze data stored in Amazon S3 using standard SQL without managing servers. It is a good fit for ad hoc analysis of data lake files and querying logs stored in S3.
How much does Amazon Athena cost?
Amazon Athena is a paid product with no free plan. Usage-based. SQL queries cost $5 per TB scanned, Capacity Reservations $0.30 per DPU-hour and Apache Spark $0.35 per DPU-hour. S3 storage and requests are billed separately.
Is Amazon Athena open source?
No. Amazon Athena is proprietary (closed-source) software and can't be self-hosted. Open-source alternatives to Amazon Athena include Trino, DuckDB and ClickHouse.
What are some alternatives to Amazon Athena?
Amazon Athena competes with Google BigQuery, Amazon Redshift and Snowflake. For open-source options, see Enlisted's ranked list of open-source Amazon Athena alternatives.

Open-source alternatives to Amazon Athena

See all

SaaS alternatives to Amazon Athena

See all