Ravi Sir's Cards › AWS
Athena cost control
This revision card explains Athena cost control. It starts from the need that SELECT * over terabytes scans huge bytes and surprises the bill. It describes athena charges by data scanned. Columnar formats, partitions, and column projection cut bytes. The how-to section notes SELECT needed columns; WHERE on partition keys; set workgroup bytes limits and alerts. An example on the card is query drops from 120 GB scanned to 2 GB after Parquet + date filter.
Read card text
What this card says
Why do we need it?
SELECT * over terabytes scans huge bytes and surprises the bill.
What is it?
Athena charges by data scanned. Columnar formats, partitions, and column projection cut bytes.
per scan
How to do it
SELECT needed columns; WHERE on partition keys; set workgroup bytes limits and alerts.
Example
Query drops from 120 GB scanned to 2 GB after Parquet + date filter.