Error: dynamodb scan missing values

Scan results can look incomplete because only one page was read, a filter removed items, or a projection omitted attributes. Separate missing items from missing fields. Adding a filter cannot restore data excluded by a projection or a skipped page.

import boto3

db = boto3.client("dynamodb", region_name="us-west-2")
for page in db.get_paginator("scan").paginate(TableName="Orders"):
    for item in page.get("Items", []):
        print(item)

For diagnosis, remove ProjectionExpression and FilterExpression from a read-only scan of an appropriately sized dataset. Then add each back and compare Count with ScannedCount. A filtered scan can return zero items and still have LastEvaluatedKey.

A GSI scan sees only indexed items and projected fields. Items lacking index keys are absent from that index; read the base table when you need the full item. Optional non-key fields can genuinely be missing. ConsistentRead=true on a base-table Scan gives consistent item reads, not a snapshot of the entire table during concurrent writes.

See scan pagination and AWS documentation.