Reduce Amazon Athena costs with these tips

Query data in S3 using SQL

Amazon Athena cost saving tips

Optimize your Amazon Athena costs with these tips

Compress & Partition Data

Compressing and partitioning your data based on common query filters reduces the amount of data scanned by Athena queries, lowering costs.

Use Columnar Formats

Using columnar formats like ORC and Parquet lets Athena read only necessary columns for a query, reducing data scanned and costs.

Analyze Query Performance

By reviewing query performance logs regularly, inefficient queries can be identified and optimized, improving performance and reducing costs.

Service information & pricing

About Amazon Athena

About Amazon Athena

Amazon Athena is a serverless analytics service for easy, flexible analysis of large data. It supports diverse sources and frameworks with clear pricing, built on open-source engines. Without needing provisioning or setup, it's used for running queries, machine learning data prep, building reconciliation engines, and multicloud analytics. Companies such as FINRA, Siemens Mobility, Cargotec, and Betterment use Athena, with tutorials and FAQs available for beginners.

Learn more

Amazon Athena pricing

SQL queries within AWS are charged based on the amount of data scanned per query, rounded up to the nearest megabyte with a 10 MB minimum. There are no charges for Data Definition Language statements or failed queries, however, cancelled queries are billed for the total amount of data scanned. The cost can be reduced by up to 90% by compressing, partitioning, and converting your data into columnar formats, which also improves performance. The price for SQL queries is per TB of data scanned.

Learn more