AWS Athena

2 documented AWS Athena cost inefficiencies, each with how to detect it and how to fix it.

2 inefficiencies

AWS AthenaCER-0136
Unmanaged Growth of Athena Query Output Buckets
When a workgroup writes results to a customer-managed S3 location, Athena generates a new S3 object for every query result, regardless of whether the output is needed long term. Over time, this leads to uncontrolled growth of the output...
Storage
AWS AthenaCER-0188
Inefficient File Format and Layout for Athena Queries
Storing raw JSON or CSV files in S3 - especially when written frequently in small batches-leads to excessive scan costs in Athena. These formats are row-based and verbose, requiring Athena to scan and parse the full content even when only...
Compute