Databricks
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
Open-source alternatives to Amazon Athena
See all
Trino
Databases
Official repository of Trino, the distributed SQL query engine for big data, formerly know
Apache-2.0vs Amazon Redshift★ 13k
ClickHouse
Databases
ClickHouse is a fast open-source column-oriented database management system that allows ge
Apache-2.0vs Snowflake★ 50k
DuckDB
Databases
DuckDB is an analytical in-process SQL database management system
MITvs MotherDuck★ 42k
Apache Doris
Databases
Apache Doris is a real-time analytics and hybrid search database for AI agents.
Apache-2.0vs Snowflake★ 16k
StarRocks
Databases
The world's fastest open query engine for sub-second analytics both on and off the data la
Apache-2.0vs Snowflake★ 12k
Databend
Databases
Data Agent Ready Warehouse : One for Analytics, Search, AI, Python Sandbox. — rebuilt fr
OSSvs Snowflake★ 9.5k
SaaS alternatives to Amazon Athena
See all
Google BigQuery
Databases
Serverless data warehouse for SQL analytics on large datasets
SaaS
Amazon Redshift
Databases
Managed cloud data warehouse on AWS for SQL analytics at scale
SaaS
Snowflake
Databases
Cloud data platform for warehousing, data sharing and analytics
SaaS
Starburst
Databases
Data lakehouse analytics platform built on the Trino query engine
SaaS
Azure Synapse Analytics
Databases
Microsoft analytics service combining data warehousing, big data and data integration
SaaS
Azure Data Explorer
Databases
Analytics service on Azure for exploring log, telemetry and time-series data with Kusto queries
SaaS