How to show only unique rows in CloudWatch output?

user_16140615 0
Viewed 290

I have a CloudWatch query that creates a table of output that looks something like:

id    | name   | age
1313  | Sam    | 24 
1313  | Sam    | 24 
1313  | Sam    | 24 
1481  | David  | 62
1481  | David  | 62
3748  | Sarah  | 37
3748  | Sarah  | 37
3748  | Sarah  | 37
1481  | David  | 62

(All example values)

Is there a way to have CloudWatch automatically deduplicate its output, so I just see:

id    | name   | age
1313  | Sam    | 24 
1481  | David  | 62
3748  | Sarah  | 37
amazon-cloudwatch amazon-web-services
1 Answers

You can calculate an aggregated value across these 3 fields and then drop it (keep just these 3). Like this for example:

YOUR CURRENT QUERY | count(*) by id, name, age | display id, name, age
user_18039900
Related