A data engineer notices slow query performance on a highly partitioned table that is in...

Use an AWS Lambda function that runs daily. Configure the function to manually create new partitions in AW5 Glue for each day's data.

Use partition projection in Athena. Configure the table properties by using a date range from 5 years ago to the present.

Reduce the number of partitions by changing the partitioning schema from dairy to monthly granularity.

Increase the processing capacity of Athena queries by allocating more compute resources.