Amazon Athena
aws.amazon.com
- Web
- API
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
Plans
Every plan and priceSQL queries with Capacity Reservations
Apache Spark
SQL queries
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.