Amazon Athena
Serverless, interactive SQL query service querying Amazon S3 data lakes directly with Presto/Trino ($5.00/TB scanned).
Serverless, interactive SQL query service querying Amazon S3 data lakes directly with Presto/Trino ($5.00/TB scanned).
Coming from Google Cloud?
Amazon Athena is the direct AWS architectural twin to BigQuery On-Demand / BigLake, charging $5.00 per TB scanned over data lake files.
- 100% serverless SQL engines with $0 idle cost and zero cluster management.
- Billed strictly on data scanned ($5.00 per TB).
- Optimized by converting raw data to columnar Parquet/ORC format.
- Storage: BigQuery stores data in proprietary Capacitor format by default; Athena queries open Parquet/Iceberg files in standard S3 buckets.
- Metastore: Athena relies on the AWS Glue Data Catalog; BigQuery has an integrated internal metadata engine.
- SQL Dialect: Athena uses ANSI Presto/Trino SQL; BigQuery uses GoogleSQL.
What is Amazon Athena?
Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run. It is built on open-source Trino (Presto) and Apache Spark engines, with native integration with the AWS Glue Data Catalog.
Decision Guide: When to Choose This Service
Use Amazon Athena for serverless ad-hoc data lake analytics, querying raw logs in S3, analyzing Apache Iceberg tables, and cost-effective data exploration with $0 idle compute charges.
Do NOT use Amazon Athena for high-throughput sub-second OLTP transactions, high-concurrency BI dashboards requiring sub-50ms latency (use Redshift with SPICE instead).
Core Architectural Pillars
Pay strictly for bytes scanned from Amazon S3 ($0 idle cost).
Central Hive-compatible metastore resolving schemas and partitions.
Calculates S3 folder prefixes dynamically in memory without catalog lookups.
Query Parquet, ORC, JSON, CSV, Apache Iceberg, Delta Lake, and Hudi tables.