Export tab separated data
aws dynamodb scan `
--table-name table_name `
--query "Items[*].[Id.S, Status.S]" `
--region us-wet-2 `
--output text
Use Scan filter with count
aws dynamodb scan `
--table-name table_name `
--select "COUNT" `
--region us-west-2 `
--scan-filter file://scan.json
in scan.json
{"Status":{"ComparisonOperator":"CONTAINS", "AttributeValueList":[{"S":"none"}]}}