Caching Amazon Athena Query Results with DynamoDB and Managed Query Results
Amazon Athena on Apache Iceberg is a natural fit for analytics dashboards, but every query carries a fixed overhead of one to several seconds, even when the result is a single number. Dashboards auto-refresh and get opened by many users, so the same queries run again and again, paying that latency and the scan bill every time. Athena ships a built-in Query Result Reuse feature, but it refuses to run in a workgroup that uses Managed Query Results.