Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Amazon Athena

aws.amazon.com

  • Web
  • API
6.3 Club score Visit aws.amazon.com

What Amazon Athena is

Amazon Athena is a cloud, serverless service for running interactive SQL queries on data in Amazon S3. It automatically scales execution and runs queries in parallel, including on large datasets and complex workloads. Its SQL engine is based on Trino and Presto and supports ANSI SQL features such as large joins, window functions, and arrays. Athena reads CSV, JSON, ORC, Avro, and Parquet files. Queries can be submitted through the console, API, CLI, AWS SDK, or supported BI and SQL development applications using JDBC or ODBC drivers. AWS Glue integration and built-in connectors reach 30 data stores, including Amazon Redshift, DynamoDB, Google BigQuery, Azure Synapse, Snowflake, and SAP Hana. SQL can invoke models deployed on Amazon SageMaker for inference. Workgroups separate users or workloads, set processing limits, and track costs. Access controls include IAM, access control lists, and S3 bucket policies, with support for encrypted data and results. SQL query pricing starts at $5 a month, billed by data scanned.

Who it suits

Athena suits teams exploring S3 data with SQL across cloud, on-premises, and other data stores. It also fits organizations needing workgroup controls, connectors, or SageMaker inference.

Good to know, and what to watch

  • Serverless interactive SQL on S3
  • Supports common analytical file formats
  • Connectors to 30 data stores
  • Workgroups set limits and track costs
  • Queries can invoke SageMaker models
  • No free plan is listed
  • S3 and related service charges apply separately
  • Glue Data Catalog charges may apply
  • Usage-based pricing depends on data scanned

SQL queries with Capacity Reservations

$0.30/mo

Apache Spark

$0.35/mo

SQL queries

$5/mo

The verdict

Amazon Athena provides serverless SQL analysis with broad connector, format, security, and workload controls. Review scan-based pricing and additional AWS charges when estimating usage.

What the maker publishes

Additional charges
S3 storage, requests, and data transfer are billed at standard S3 rates, and use of the AWS Glue Data Catalog incurs its standard rates. source
Compliance
AWS documentation says third-party auditors assess security and compliance under AWS programs including SOC, PCI, and FedRAMP; customer compliance responsibility depends on their data and obligations. source
Data formats
Supported formats include CSV, JSON, ORC, Avro, and Parquet. source
Integrations
Athena integrates with AWS Glue and offers built-in connectors to 30 data stores, including Amazon Redshift, Amazon DynamoDB, Google BigQuery, Azure Synapse, Snowflake, and SAP Hana. source
Intended use
AWS describes Athena as suited to interactive SQL queries and data exploration across S3, other clouds, and on-premises sources. source
Machine learning
Athena SQL queries can invoke machine-learning models deployed on Amazon SageMaker for inference. source
Maker
Amazon.com, Inc. was incorporated in 1994 and lists its principal corporate offices in Seattle, Washington. source
Purpose
Amazon Athena is a serverless interactive query service for analyzing data in Amazon S3 with standard SQL. source
Query access
Athena queries can be run from its console, API, CLI, AWS SDK, and supported BI and SQL development applications using JDBC or ODBC drivers. source
Scale
Athena automatically scales and runs queries in parallel, including on large datasets and complex queries. source
Security
Access to data can be controlled with IAM policies, access control lists, and S3 bucket policies, and Athena supports querying encrypted S3 data and writing encrypted results. source
SQL engine
Athena for SQL is based on Trino and Presto and supports ANSI SQL features including large joins, window functions, and arrays. source
Workgroups
Workgroups can separate users, teams, applications, or workloads, set per-query or group data processing limits, and track costs. source

Checked against the maker's pages on 3 Oct 2026.