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.
- 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.