Amazon DynamoDB Json support while querying and scanning
<p>After a painful day trying to figure out if we should go with DynamoDB to store Json documents (vs mongo) and reading through almost all the AWS documentations and online examples, I have decided to ask my questions here. </p>

<p>Ours is a Spring Boot Java application and we are using the aws-dynamodb sdk plugin. Our application has to manage a couple of thousands of Json documents and be able to retrieve based on various conditions.</p>

<p>For example, imagine this is the JSon document - </p>

<pre><code>{ 
"serial":"123123",
"feed":{
      "ABC":{
          "queue": "ABC",
          "active": true
            },
       "XYZ" : {
           "queue":"XYZ",
           "active": false
 }
}
</code></pre>

<p>These are the questions I have </p>

<ol>
<li><p>Can I store this whole Json document as a String attribute in Dynamo table and still be able to retrieve the records based on the value of certain attributes inside the Json and how?
For example I would like to get all the items that has the feed ABC active.</p></li>
<li><p>How scalable is this solution?</p></li>
</ol>

<p>I know I can do this very easily in Mongo but just couldn't get it working in dynamo. </p>