AWS cli query examples

using the query option in aws cli makes it very easy to work with cli

below are few examples of using JMESPath query :

•   use of contains

 aws emr list-clusters --region us-east-1 --query 'Clusters[?Name==`{{ clustername }}`]|[?contains(Status.State, `TERMINATED`) == `false`].[Id]

• use of length to get the count

aws emr list-clusters --region us-east-1 --query 'Clusters[?Name==`{{ current_run_reference }}`]|[?contains(Status.State, `TERMINATED`) == `false`].[Id]|length(@)' 

• list route53 records of a IP

aws route53 list-resource-record-sets --hosted-zone-id ZXXXXXXXXXXXXX --query 'ResourceRecordSets[?ResourceRecords[0].Value==`10.253.xx.xxx`]' 

• Filter with more than one condition

aws route53 list-resource-record-sets --hosted-zone-id ZXXXXXXXXXXXXX --query 'ResourceRecordSets[?ResourceRecords[0].Value==`10.253.xx.xx`]|[?Type==`CNAME`]'