CloudWatch Metrics - Max time window exceeded for SQL query

Question

Hi, I created a graph on CloudWatch using a query. If the graph is set to 3h or less, it's displaying. But when it's set to anything greater than 3h, its displaying a Max time window exceeded for SQL query error. Is there any limit I should adjust to make my query work?

This is the query I'm using

SELECT AVG("4XXError") FROM SCHEMA("AWS/ApiGateway") WHERE ApiName = 'apiname' AND Stage = 'stage'

TIA

This is the query I'm using
```
SELECT AVG("4XXError") FROM SCHEMA("AWS/ApiGateway") WHERE ApiName = 'apiname' AND Stage = 'stage'
```

TIA

Accepted Answer

See [GetMetricData documentation](https://docs.aws.amazon.com/AmazonCloudWatch/latest/APIReference/API_GetMetricData.html):

```
Metrics Insights queries can query only the most recent three hours of metric data.
```
That is currently a hard limit and there is nothing you can do to extend.

Answer

"fixed" it for our use case (displaying uptimes of ecs tasks) for now by setting the intervals here: 
![Enter image description here](/media/postImages/original/IMaJRqCMzvRzSYKvTU2nFy3A)

CloudWatch Metrics - Max time window exceeded for SQL query

Relevant content