Reduce Amazon Athena costs with these tips
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.
Discover your infrastructure maturity
Curious about the state of your digital infrastructure? Our Infrastructure Maturity Assessment provides immediate results, offering you a clear understanding of your setup’s strengths and areas for improvement.
The Infrastructure Maturity Assessment is a quick and free tool designed to evaluate the quality and readiness of your digital infrastructure. In just a few minutes, you’ll receive personalized insights to help you enhance scalability, efficiency, and performance.
Ready to see how your digital infrastructure stacks up?
It only takes 10-15 minutes, and your results are available instantly!
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.
- 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.