Query: CacheHit sum below 10 of an elasticache cluster for the last 7 days

Description

Determine the performance of an ElastiCache cluster over the past week by identifying instances where cache hit sums were less than 10. This can be useful for analyzing the effectiveness of your cache configuration and identifying potential areas for improvement.

Query

Tables used in this query:

• aws_cloudwatch_metric_data_point

SQL