CloudWatch: Cross-account observability user not getting all metrics

slack conversation here: https://raintank-corp.slack.com/archives/C018A4U4BU2/p1723661785366509 Cross-account observability users are having trouble with not getting all their metrics from CloudWatch because we don't paginate the query, so their hitting the metrics limit. From the aws docs: "A GetMetricData operation that does not include a query can retrieve as many as 500 different metrics in a single request, with a total of as many as 100,800 data points." our code here: https://github.com/grafana/grafana/blob/f6b55ced6f41f0caac63d09d9e96933516e1871b/pkg/tsdb/cloudwatch/get_metric_data_executor.go#L29 we should be using GetMetricDataPagesWithContext: https://pkg.go.dev/github.com/aws/aws-sdk-go/service/cloudwatch#CloudWatch.GetMetricDataPagesWithContext Edit: we do paginate, and we're talking to AWS about how we can work around the limits, which are on queries from their side: https://repost.aws/questions/QUG6oH-yt-RDaHq2QRhtdBKQ/cloudwatch-metrics-getmetricdata-error-maximum-number-of-allowed-metrics-exceeded-your-search-may-have-been-limited