The most reliable way to build a system with DynamoDB is to plan queries upfront. Trying to use it like a SQL database and make Ad-Hoc queries won't work because it's not a SQL DB.

Data should be stored in the fashion you wish for it to be read, and storing the same data in more than one configuration is acceptable.

Good resource: https://docs.aws.amazon.com/amazondynamodb/latest/developerg...