Composite sort key pattern in DynamoDB - Step-by-Step Execution

Concept Flow - Composite sort key pattern

Start: Query with Partition Key

↓

Apply Sort Key Filter

↓

Sort Items by Sort Key

↓

Return Filtered and Sorted Results

↓

End

The query starts by selecting items with the same partition key, then filters and sorts them using the composite sort key pattern to organize results.

Execution Sample

DynamoDB

PartitionKey = 'User#123'
SortKey begins_with 'Order#2023#'
Query DynamoDB with these keys

This query fetches all orders for user 123 from 2023 by filtering and sorting on the composite sort key.

Execution Table

Step	Action	Partition Key Filter	Sort Key Condition	Items Matched	Resulting Order
1	Start query	User#123	SortKey begins_with 'Order#2023#'	All items with PartitionKey='User#123'	Unsorted
2	Filter items	User#123	SortKey begins_with 'Order#2023#'	Items: Order#2023#001, Order#2023#002, Order#2023#010	Unsorted
3	Sort items	User#123	SortKey prefix filter applied	Same 3 items	Sorted ascending by SortKey: Order#2023#001, Order#2023#002, Order#2023#010
4	Return results	User#123	SortKey prefix filter applied	3 items	Final sorted list returned

💡 Query ends after returning all items matching partition key and sort key prefix, sorted by sort key.

Variable Tracker

Variable	Start	After Step 1	After Step 2	After Step 3	Final
PartitionKey	undefined	User#123	User#123	User#123	User#123
SortKey Condition	undefined	begins_with 'Order#2023#'	begins_with 'Order#2023#'	begins_with 'Order#2023#'	begins_with 'Order#2023#'
Matched Items	[]	All with User#123	Filtered to 3 orders	Sorted 3 orders	3 sorted orders

Key Moments - 2 Insights

Why do we need to use a composite sort key instead of just a simple sort key?

Because the composite sort key combines multiple pieces of information (like year and order number) into one string, it allows filtering and sorting on multiple criteria in one step, as shown in execution_table rows 2 and 3.

What happens if the sort key condition is not applied?

Without the sort key condition, the query would return all items with the partition key, unsorted and unfiltered, as shown in execution_table row 1, which can be inefficient and return too many results.

Visual Quiz - 3 Questions

Look at the execution_table, at which step are the items sorted by the composite sort key?

A Step 2

B Step 3

C Step 1

D Step 4

💡 Hint

Check the 'Resulting Order' column in execution_table rows.

According to variable_tracker, what is the value of 'Matched Items' after Step 2?

A Filtered to 3 orders

B Empty list []

C All items with PartitionKey 'User#123'

D Sorted 3 orders

💡 Hint

Look at the 'Matched Items' row under 'After Step 2' in variable_tracker.

If the sort key condition was changed to 'begins_with Order#2022#', how would the matched items change?

A They would include orders from 2023

B No items would match

C They would include orders from 2022

D All items with PartitionKey would match

💡 Hint

Refer to how the sort key prefix filters items in execution_table row 2.

Concept Snapshot

Composite sort key pattern in DynamoDB:
- Use PartitionKey to group related items.
- Use composite SortKey combining multiple values (e.g., 'Order#2023#001').
- Query with PartitionKey and SortKey condition (e.g., begins_with).
- DynamoDB returns items filtered and sorted by SortKey.
- Enables efficient queries with multiple criteria in one key.

Full Transcript

The composite sort key pattern in DynamoDB helps organize and query data efficiently. First, you select items by their partition key, which groups related data. Then, you apply a condition on the sort key, which is a combined string of multiple values like year and order number. This filters and sorts the items in one step. The execution table shows how the query starts with all items for a user, filters to those starting with 'Order#2023#', sorts them, and returns the final list. Variables like PartitionKey and SortKey condition remain constant, while matched items change as filtering and sorting happen. Key moments clarify why the composite sort key is useful and what happens if the sort key condition is missing. The quiz tests understanding of sorting step, matched items after filtering, and effects of changing the sort key prefix. The snapshot summarizes the pattern as a way to combine multiple criteria into one key for efficient querying.