Scan pagination in DynamoDB

Introduction

Scan pagination helps you get all items from a big table in small parts. This avoids slow or heavy requests.

When you want to read all data but the table is too large to get at once.

When you want to show data page by page in an app or website.

When you want to avoid timeouts or limits on reading data.

When you want to process data in chunks to save memory.

When you want to control how much data you read each time.

Syntax

DynamoDB

Scan operation with ExclusiveStartKey and Limit parameters.

Example:

Scan(
  TableName='YourTable',
  Limit=10,
  ExclusiveStartKey={ 'PrimaryKey': { 'S': 'LastEvaluatedKeyValue' } }
)

Limit controls how many items you get per scan call.

ExclusiveStartKey tells DynamoDB where to continue scanning from.

Examples

Get first 5 items from the Products table.

DynamoDB

Scan(
  TableName='Products',
  Limit=5
)

Get next 5 items starting after ProductID 123.

DynamoDB

Scan(
  TableName='Products',
  Limit=5,
  ExclusiveStartKey={ 'ProductID': { 'S': '123' } }
)

Sample Program

This code reads all items from 'ExampleTable' in chunks of 3 using scan pagination. It keeps scanning until no more items remain.

DynamoDB

import boto3

client = boto3.client('dynamodb')

def scan_all_items(table_name):
    last_evaluated_key = None
    all_items = []

    while True:
        if last_evaluated_key:
            response = client.scan(
                TableName=table_name,
                Limit=3,
                ExclusiveStartKey=last_evaluated_key
            )
        else:
            response = client.scan(
                TableName=table_name,
                Limit=3
            )

        items = response.get('Items', [])
        all_items.extend(items)

        last_evaluated_key = response.get('LastEvaluatedKey')
        if not last_evaluated_key:
            break

    return all_items

# Example usage
items = scan_all_items('ExampleTable')
print(f"Total items fetched: {len(items)}")

Important Notes

Scan reads the whole table, so it can be slow for big tables.

Use pagination to avoid timeouts and large data loads.

Always check for LastEvaluatedKey to know if more data exists.

Summary

Scan pagination breaks big scans into small parts.

Use Limit to set chunk size and ExclusiveStartKey to continue.

Keep scanning until LastEvaluatedKey is empty.

Practice

1. What is the main purpose of using Scan pagination in DynamoDB?

easy

A. To speed up writes to the database

B. To delete items in batches

C. To create indexes automatically

D. To break a large scan into smaller parts for easier processing

Solution

1. Step 1: Understand Scan Pagination Concept

   Scan pagination is used to divide a large scan operation into smaller chunks to avoid timeouts and manage resource use.

2. Step 2: Identify the Purpose

   The main goal is to process big scans in parts, not to speed writes or create indexes.

3. Final Answer:

   To break a large scan into smaller parts for easier processing -> Option D

4. Quick Check:

   Scan pagination = break large scan into parts [OK]

Hint: Scan pagination splits big scans into smaller chunks [OK]

Common Mistakes:

• Thinking pagination speeds up writes
• Confusing scan with index creation
• Assuming pagination deletes items

2. Which of the following is the correct way to continue a paginated scan in DynamoDB?

easy

A. Use LastEvaluatedKey as the ExclusiveStartKey in the next scan

B. Use Limit as the ExclusiveStartKey

C. Use ScanIndexForward to continue scanning

D. Use StartKey to begin the scan

Solution

1. Step 1: Identify Pagination Parameters

   In DynamoDB, LastEvaluatedKey from the previous scan is used as ExclusiveStartKey to continue scanning.

2. Step 2: Eliminate Incorrect Options

   Limit sets chunk size, not start key. ScanIndexForward is for queries, not scans. StartKey is not a valid parameter.

3. Final Answer:

   Use LastEvaluatedKey as the ExclusiveStartKey in the next scan -> Option A

4. Quick Check:

   Continue scan = ExclusiveStartKey = LastEvaluatedKey [OK]

Hint: Use LastEvaluatedKey as ExclusiveStartKey to continue scan [OK]

Common Mistakes:

• Using Limit as ExclusiveStartKey
• Confusing scan with query parameters
• Using invalid parameter names

3. Given the following scan code snippet, what will be the output if the table has 15 items and Limit is set to 5?

response = table.scan(Limit=5)
items = response['Items']
last_key = response.get('LastEvaluatedKey')
print(len(items), last_key is not None)

medium

A. 5 False

B. 15 False

C. 5 True

D. 15 True

Solution

1. Step 1: Understand Limit Effect on Scan

   Setting Limit=5 returns up to 5 items in one scan call, not all 15.

2. Step 2: Check LastEvaluatedKey Presence

   Since there are more items after 5, LastEvaluatedKey will be present (not None), indicating more data.

3. Final Answer:

   5 True -> Option C

4. Quick Check:

   Limit=5 returns 5 items and LastEvaluatedKey exists [OK]

Hint: Limit controls items returned; LastEvaluatedKey shows more data [OK]

Common Mistakes:

• Assuming all items return ignoring Limit
• Expecting LastEvaluatedKey to be None always
• Confusing item count with total table size

4. You wrote this code to paginate a scan but it returns only the first page repeatedly:

response = table.scan(Limit=3)
items = response['Items']
while 'LastEvaluatedKey' in response:
    response = table.scan(Limit=3)
    items.extend(response['Items'])
print(len(items))

What is the error?

medium

A. Missing ExclusiveStartKey in the subsequent scan calls

B. Limit should be increased to get all items

C. Items list should be reset inside the loop

D. LastEvaluatedKey should be deleted after each scan

Solution

1. Step 1: Analyze Pagination Loop

   The loop calls scan repeatedly but does not pass ExclusiveStartKey, so it always scans from start.

2. Step 2: Identify Missing Parameter

   To continue scanning, ExclusiveStartKey must be set to previous LastEvaluatedKey in each call.

3. Final Answer:

   Missing ExclusiveStartKey in the subsequent scan calls -> Option A

4. Quick Check:

   Pagination needs ExclusiveStartKey to continue [OK]

Hint: Pass ExclusiveStartKey to continue scan pages [OK]

Common Mistakes:

• Not passing ExclusiveStartKey in loop
• Increasing Limit instead of fixing pagination
• Resetting items list inside loop

5. You want to scan a DynamoDB table with 1000 items but only want to process 100 items at a time to avoid timeouts. Which approach correctly implements scan pagination to achieve this?

hard

A. Set ExclusiveStartKey to null and scan with Limit=100 once

B. Use a loop with Limit=100 and pass ExclusiveStartKey from LastEvaluatedKey until no more keys

C. Use ScanIndexForward=true with Limit=100 to paginate

D. Scan once with Limit=1000 and split results in code

Solution

1. Step 1: Understand Pagination Requirements

   To process 100 items at a time, scan must be done in chunks with Limit=100 and continue using ExclusiveStartKey.

2. Step 2: Evaluate Options

   Use a loop with Limit=100 and pass ExclusiveStartKey from LastEvaluatedKey until no more keys correctly loops with Limit=100 and uses ExclusiveStartKey from LastEvaluatedKey. Scan once with Limit=1000 and split results in code fetches all at once, risking timeout. Use ScanIndexForward=true with Limit=100 to paginate uses wrong parameter for scan. Set ExclusiveStartKey to null and scan with Limit=100 once scans only once without continuation.

3. Final Answer:

   Use a loop with Limit=100 and pass ExclusiveStartKey from LastEvaluatedKey until no more keys -> Option B

4. Quick Check:

   Paginate with Limit and ExclusiveStartKey loop [OK]

Hint: Loop with Limit and ExclusiveStartKey until no LastEvaluatedKey [OK]

Common Mistakes:

• Fetching all items at once risking timeout
• Using query parameters for scan
• Not looping to continue scan