Athena CloudWatch Metrics Connector only returns data from the past trailing 15 days

Question & Answer
, , ,
1

I want to pull in CloudWatch Metrics data points into QuickSight, so I have set up an Athena CloudWatch Metrics connector: https://docs.aws.amazon.com/athena/latest/ug/connectors-cwmetrics.html, but when I try to set up a dataset that queries the metric_samples table, the earliest data point that gets returned is from 15 days ago.

I see from the CloudWatch UI that more data exists past 15 days ago.

I also know that CloudWatch retains the metric data based on the period of the datapoint: https://docs.aws.amazon.com/AmazonCloudWatch/latest/monitoring/cloudwatch_concepts.html, but if I try to query for data points with periods > 60 seconds, I get no results.

How can I set up a dataset in QuickSight which has CloudWatch metrics data points older than 15 days?

2

Hi,

Welcome to the QuickSight community.

Have you tried it querying cloudwatch data from Athena console. Can you please check whether data at specific granule and time window beyond 15 days available in table by SQL query from Athena console .

Regards,
Anwar Ali

3

Thanks for the tip! I had tried queries with period != 60 and period > 60 which did not work. But once I tried a query with period = 300, I was able to get older data points.