Amazon Athena adds 1-minute reservations and new capacity control features

This article announces new capabilities for Amazon Athena's Capacity Reservations feature, enabling more flexible and cost-effective management of mission-critical analytics workloads.

• Minimum capacity reduced from 24 DPU to 4 DPU for fine-grained adjustments
• Reservation duration reduced from 60 minutes to 1 minute for frequent updates
• Potential savings up to 95% for workloads completing in under an hour
• Autoscaling solution using AWS Step Functions monitors CloudWatch metrics automatically
• One-click autoscaling setup available directly from Athena console
• New DPU controls set minimum/maximum limits at workgroup or per-query level
• All queries now report DPU usage in console and APIs for visibility
• No SQL changes needed; administrators assign workgroups to reservations

These updates provide greater flexibility for dynamic workloads while maintaining Athena's serverless simplicity and improving cost optimization for mission-critical queries.