Athena Pricing Calculator - SQL Queries, Provisioned Capacity & Spark

Amazon Athena pricing is based on two models: On-demand charges $5 per TB of data scanned by your SQL queries, or provisioned capacity where you pay for DPU-hours (Data Processing Units). Queries on partitioned data and compressed formats like Parquet reduce costs by scanning less data. DDL statements and failed queries are not charged.

Reduce Athena costs by: (1) Partitioning tables to scan only relevant data, (2) Using columnar formats like Parquet or ORC with compression, (3) Limiting columns in SELECT statements instead of SELECT *, (4) Using provisioned capacity for predictable workloads, and (5) Implementing query result caching to avoid re-scanning data.

Use Athena provisioned capacity when you have predictable, high-volume query workloads that scan more than 100 TB per month. Provisioned capacity offers consistent performance with DPU-hour pricing, which can be more cost-effective than on-demand ($5/TB) for heavy users. For sporadic or unpredictable workloads, on-demand pricing is typically better.

Athena for Apache Spark charges based on DPU-hours consumed by your notebook sessions. A DPU (Data Processing Unit) provides 4 vCPUs and 16 GB of memory. Pricing varies by region, typically around $0.30-0.40 per DPU-hour. Spark applications automatically scale compute resources based on workload demands, and you only pay for actual usage time.