Not able to search on nested property in DynamoDB AWS console

Question

Is it possible to search on nested properties from AWS DynamoDB console? I am able to search on all top level properties, but search on any nested properties always results in empty result set.

For example for the document provided below I am able to scan and add filter on any top level field, like id, name, etc.

However I am unable to scan, and filter on device. I am trying the filter as device.name = 'Xaomi'

{ id: 'jhfdgu75457y8r', name: 'Parag', device: {name: 'Xaomi', country: 'China'} }

Please note that I am doing this from AWS console, and not any client library. Does AWS console allows filters on nested objects?

Answer 1

All data in DynamoDB is stored as either a string, binary or number.

When you use an SDK to access DynamoDB it will typically convert and unconvert these primatives into complex data types such as lists and maps.

The console works only on the primative data types. In this case your device attribute is treated as a string, and you cannot therefore filter by the device.name nested attribute.

You can however simply do a string filter. For example filter on the device attribute, using the contains operator and the value "name":"Xaomi"

Answer 2

It isn't currently possible on the console.

I was also looking for a solution where I can find an item based on the value of a nested property.

But it is currently possible only via the SDK or CLI and not the console.

Confirmed by the AWS support team here - https://forums.aws.amazon.com/thread.jspa?messageID=931016

Answer 3

In the Filter type "device" and not device.name and select "Contains" instead of "=" in the drop-down