AWS CLI list-data-sets query howto

Question & Answer
, ,
1

I can easily use the describe command in AWS QS CLI to find a dataset (assuming I know the hash) by using this command:
aws quicksight describe-data-set --aws-account-id 123456789012 --data-set-id 67bbee6b-f988-4723-9d6f-a4b7e57991ab

which returns this:
{
“Status”: 200,
“DataSet”: {
“Arn”: “arn:aws:quicksight:us-west-2:123456789012:dataset/67bbee6b-f988-4723-9d6f-a4b7e57991ab”,
“DataSetId”: “67bbee6b-f988-4723-9d6f-a4b7e57991ab”,
“Name”: “BusIntelPacing”,

however when I try to use the list-data-sets --query I get a null response

aws quicksight list-data-sets --aws-account-id 123456789012 --query DataSet[?Name==‘BusIntelPacing’].Arn

this is what the above command returns
C:\Users\greenac>aws quicksight list-data-sets --aws-account-id 123456789012 --query DataSet[?Name==‘BusIntelPacing’].Arn
null
C:\Users\greenac>

Why am I receiving a null response?

2

Query should be like aws quicksight list-data-sets --aws-account-id 123456789012 --query "DataSetSummaries[?Name==‘BusIntelPacing’].Arn"

the –query argument must extract data from the results of the following query expressions: 'DataSetSummaries' according to list-data-sets — AWS CLI 1.30.3 Command Reference

3

thanks for the quick reply.