AWS-Console: DynamoDB scan on nested field

Question

I have below table in DynamoDB

{
    "id": 1,
    "user": {
        "age": "26",
        "email": "[email protected]",
        "name": "test user"
    }
}

Using AWS console, I want to scan all the records whose email address contains gmail.com

I am trying this but it is giving no results.

I am new to AWS, not sure what's wrong here. Is it not possible to scan on nested fields?

Answer 1

I've been trying to figure this out myself but it would seem that nested item scans are not supported through the console.

I'm going based off of this which offer some alternative options via CLI or SDK: https://forums.aws.amazon.com/thread.jspa?messageID=931016