datapundittechblogs

  Lets us Scan Complete DynamoDB Table: Python Boto3 How to Query full dynamo DB table with filters in place In this blog, we will see examples of how to do a full query of a dynamo DB table. We will also see in more details with code, the concepts of applying filters and conditions to obtain only required records. Why we need to filter the records? The question is why do we need to scan the DB if we can fetch the records based on the partition key and sort key? Case 1. When we need to list all the partition key and sort keys Case2. When we need to take a snapshot of the data and back it up or replicate it up in the AWS S3 as S3 is cost effective and comes with flavor of Intelligent Tiering. warning:  SCAN is a costly operation as it has to scan through the complete table so where ever possible , use query operation instead scan. Please see my Youtube video to see the explanation of the 2 scan operation: Video 1 while applying a single Filter on the Table Please create the table as req