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?

NLSteveO · Accepted Answer · 2020-07-13 14:25:00Z

2

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

answered Jul 13, 2020 at 14:25

NLSteveO

481 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

You can try this tool (docs.aws.amazon.com/amazondynamodb/latest/developerguide/…). It has the option to add filter on nested fields. Go to "Operation builder" tab.