AWS Athena

AWS Athena is a serverless, interactive query service that makes it easy to analyze data directly in Amazon S3 using standard SQL. It allows users to run ad-hoc queries on petabytes of unstructured, semi-structured, and structured data without provisioning or managing any servers.

Key facts

First appeared: 2016
Category: technology
Problem solved: AWS Athena was created to simplify and democratize the process of querying vast datasets stored in Amazon S3. Prior to Athena, users typically had to set up and manage complex, expensive clusters like Hadoop, Hive, or self-managed Presto/Trino instances to perform ad-hoc SQL queries, which was cumbersome for intermittent analysis, incurred costs for idle compute, and required significant operational overhead.
Platforms: Amazon Web Services (AWS) Cloud

Related technologies

AWS Glue Data Catalog
Apache ORC
Amazon Kinesis Firehose
Apache Iceberg
AWS Lambda
Apache Parquet
Amazon QuickSight
Delta Lake
Amazon S3

Notable users

Capital One
Many enterprises leveraging AWS data lakes for analytics, logs, and IoT data processing.
Expedia
Netflix