whichdb

Amazon Athena

active

by Amazon Web Services · since 2016 · also known as Athena

Serverless AWS query service running Trino-based SQL directly over data in S3.

relationalcolumnar / olapmanaged serviceproprietarymature
Website Docs Compare Find similar

Overview

Amazon Athena lets you run SQL over files in S3 with nothing to provision: tables live in the AWS Glue Data Catalog and queries run on a managed Trino-based engine (engine version 3), billed per terabyte scanned or via provisioned capacity. It supports Iceberg tables with inserts, updates, merges and time travel, federated connectors via Lambda, and Spark notebooks. Athena is ideal for ad-hoc and infrequent queries over logs and lake data in AWS; for steady, high-concurrency BI, Redshift or a dedicated engine is usually cheaper and faster.

LakehouseAnalytics (OLAP)Data warehouse

Strengths & trade-offs

Strengths

  • +No infrastructure: query S3 data immediately via the Glue Catalog
  • +Pay only for data scanned; cheap for infrequent queries
  • +Iceberg DML, MERGE and time travel on S3
  • +Federated queries to DynamoDB, RDS and others via Lambda connectors
  • +Integrates with Lake Formation for fine-grained permissions

Trade-offs

  • −Per-TB pricing punishes unpartitioned or row-format data
  • −Query queuing and concurrency quotas under load
  • −Trails upstream Trino features and versions
  • −AWS-only

Great for

  • +Ad-hoc SQL over S3 logs (CloudTrail, ALB, VPC flow)
  • +Serverless lakehouse queries on Iceberg
  • +Lightweight BI on curated S3 data

Think twice for

  • −High-concurrency dashboards
  • −Low-latency APIs
  • −Non-AWS environments

Capabilities

Native or official first-party support · 5 of 25 tracked

✓Joins
✓Geospatial
✓JSON
✓Role-based access
✓Time travel
–Transactions
–Secondary indexes
–Full-text search
–Vector search
–Change data capture
–Triggers
–Stored procedures
–Materialized views
–TTL / expiry
–Pub/Sub
–Columnar storage
–In-memory
–Durable persistence
–Compression
–Encryption at rest
–Branching
–Online schema changes
–Streaming ingest
–Offline sync
–Runs in WebAssembly

Scale & consistency

Comfortable data size
Massive · Multi-PB
Horizontal scaling
Native
Multi-region
No
Transactions
Limited ACID
Consistency
Strong
Schema
Strict
Architecture
Serverless, Distributed
Query languages
SQL (Trino dialect), PySpark

Fully managed; concurrency limited by account quotas unless provisioned capacity is used.

Deployment

Self-hosted Vendor-managed cloud Serverless Embedded Edge Kubernetes operator

available on · AWS

Ecosystem

apis & protocolsAWS SDK / Athena API, JDBC, ODBC
client languagesPython, Java, JavaScript, Go, .NET

Alternatives to Amazon Athena

Compare all→
TrinoRelational49.9

Fast distributed SQL query engine for federated analytics across lakes and databases.

amazon-athena vs trino →
Amazon RedshiftColumnar / OLAP55.8

AWS's MPP columnar data warehouse, available as provisioned RA3 clusters or Serverless.

amazon-athena vs amazon-redshift →
Google BigQueryColumnar / OLAP65.3

Google's serverless, pay-per-query data warehouse built on Dremel and Colossus.

amazon-athena vs google-bigquery →
StarburstRelational0.0

Commercial Trino platform: self-managed Starburst Enterprise and the Starburst Galaxy SaaS.

amazon-athena vs starburst →
PrestoRelational37.7

Distributed SQL query engine from Meta for interactive queries over data lakes and many sources.

amazon-athena vs presto →
DremioRelational12.7

Iceberg-native lakehouse query engine with reflections for acceleration, owned by SAP since 2026.

amazon-athena vs dremio →

Amazon Athena FAQ

What is Amazon Athena?

Amazon Athena is a relational database by Amazon Web Services, first released in 2016. Amazon Athena lets you run SQL over files in S3 with nothing to provision: tables live in the AWS Glue Data Catalog and queries run on a managed Trino-based engine (engine version 3), billed per terabyte scanned or via provisioned capacity. It supports Iceberg tables with inserts, updates, merges and time travel, federated connectors via Lambda, and Spark notebooks. Athena is ideal for ad-hoc and infrequent queries over logs and lake data in AWS; for steady, high-concurrency BI, Redshift or a dedicated engine is usually cheaper and faster.

Is Amazon Athena open source?

No. Amazon Athena is proprietary, closed-source software.

Does Amazon Athena support ACID transactions?

Partly. Amazon Athena offers limited ACID guarantees (for example, single-record or single-partition transactions), with strong consistency.

Does Amazon Athena scale horizontally?

Amazon Athena scales horizontally out of the box, with built-in sharding or partitioning. It is comfortable at massive scale (Multi-PB).

How can I run Amazon Athena?

You can use the vendor's managed cloud and run it serverless. It is available on AWS.

What is Amazon Athena best for?

Amazon Athena is a strong fit for ad-hoc SQL over S3 logs (CloudTrail, ALB, VPC flow); serverless lakehouse queries on Iceberg; and lightweight BI on curated S3 data. Think twice for high-concurrency dashboards.

What are the best alternatives to Amazon Athena?

Common alternatives to Amazon Athena include Trino, Amazon Redshift, Google BigQuery, Starburst and Presto. The right choice depends on your workload, scale and hosting; WhichDB's smart match ranks them against your requirements.

How popular is Amazon Athena?

Amazon Athena ranks #166 of 844 databases on the WhichDB Score (19.5/100), and #53 among relational databases. The score combines public adoption signals such as package downloads, GitHub activity, job posts and developer discussion.