Idempotency tokens in DynamoDB - Mini Project: Build & Apply

Idempotency Tokens with DynamoDB

📖 Scenario: You are building an online order system where customers can submit orders. Sometimes, customers might accidentally send the same order twice due to network issues. To prevent creating duplicate orders, you will use idempotency tokens stored in a DynamoDB table.

🎯 Goal: Create a DynamoDB table to store orders with an idempotency_token as the primary key. Then, write a query to check if an order with a given idempotency_token already exists before adding a new order.

📋 What You'll Learn

Create a DynamoDB table named Orders with idempotency_token as the partition key.

Add a sample order item with a specific idempotency_token and order details.

Create a variable called token_to_check with the idempotency token value to search.

Write a query to check if an order with token_to_check exists in the Orders table.

💡 Why This Matters

🌍 Real World

Idempotency tokens help prevent duplicate processing of the same request in systems like online ordering, payment processing, and API calls.

💼 Career

Understanding idempotency tokens and how to use them with DynamoDB is important for backend developers and database engineers working on reliable and fault-tolerant systems.

1

Create the DynamoDB table with idempotency_token as the primary key

Create a DynamoDB table named Orders with idempotency_token as the partition key of type String.

DynamoDB

# Your code here to create the Orders table with idempotency_token as partition key

Hint

Use CREATE TABLE Orders and define idempotency_token as the primary key of type STRING.

2

Add a sample order item with an idempotency token

Insert an order item into the Orders table with idempotency_token set to 'token123', order_id as 'order001', customer_name as 'Alice', and order_amount as 100.

DynamoDB

CREATE TABLE Orders (
  idempotency_token STRING PRIMARY KEY,
  order_id STRING,
  customer_name STRING,
  order_amount NUMBER
);

# Your code here to insert a sample order with idempotency_token 'token123'

Hint

Use INSERT INTO Orders with the exact values for idempotency_token, order_id, customer_name, and order_amount.

3

Create a variable for the idempotency token to check

Create a variable called token_to_check and set it to the string 'token123' to represent the idempotency token you want to search for.

DynamoDB

CREATE TABLE Orders (
  idempotency_token STRING PRIMARY KEY,
  order_id STRING,
  customer_name STRING,
  order_amount NUMBER
);

INSERT INTO Orders (idempotency_token, order_id, customer_name, order_amount) VALUES ('token123', 'order001', 'Alice', 100);

# Your code here to create token_to_check variable with value 'token123'

Hint

Define token_to_check as a string variable with the value 'token123'.

4

Write a query to check if the idempotency token exists

Write a SELECT query to find if an order with idempotency_token equal to token_to_check exists in the Orders table.

DynamoDB

CREATE TABLE Orders (
  idempotency_token STRING PRIMARY KEY,
  order_id STRING,
  customer_name STRING,
  order_amount NUMBER
);

INSERT INTO Orders (idempotency_token, order_id, customer_name, order_amount) VALUES ('token123', 'order001', 'Alice', 100);

token_to_check = 'token123'

# Your code here to select orders where idempotency_token equals token_to_check

Hint

Use SELECT * FROM Orders WHERE idempotency_token = 'token123' to check if the token exists.

Practice

1. What is the main purpose of using idempotency tokens in DynamoDB operations?

easy

A. To encrypt data stored in the database

B. To prevent duplicate writes when the same request is retried

C. To speed up query performance by caching results

D. To automatically backup data at regular intervals

Solution

1. Step 1: Understand idempotency token role

   Idempotency tokens are unique values sent with requests to ensure the same operation is not applied multiple times.

2. Step 2: Identify the main benefit in DynamoDB

   This prevents duplicate writes if a request is retried due to network issues or timeouts.

3. Final Answer:

   To prevent duplicate writes when the same request is retried -> Option B

4. Quick Check:

   Idempotency tokens prevent duplicates = C [OK]

Hint: Idempotency tokens stop repeated writes on retries [OK]

Common Mistakes:

• Confusing idempotency tokens with encryption keys
• Thinking they improve query speed
• Assuming they trigger backups automatically

2. Which of the following is the correct way to include an idempotency token in a DynamoDB PutItem request using AWS SDK?

easy

A. "IdempotencyToken": "unique-token-value" inside the item attributes

B. Adding IdempotencyToken as a reserved keyword in the table schema

C. Setting IdempotencyToken as a parameter outside the item attributes

D. Using a conditional expression with attribute_not_exists(IdempotencyToken)

Solution

1. Step 1: Understand how idempotency tokens work in DynamoDB

   They are used with conditional expressions to ensure the item is only created if the token does not exist.

2. Step 2: Identify correct syntax for conditional check

   The expression attribute_not_exists(IdempotencyToken) prevents overwriting if the token is already present.

3. Final Answer:

   Using a conditional expression with attribute_not_exists(IdempotencyToken) -> Option D

4. Quick Check:

   Conditional check with attribute_not_exists = B [OK]

Hint: Use conditional expression attribute_not_exists for idempotency [OK]

Common Mistakes:

• Placing token inside item without condition causes duplicates
• Trying to set token outside request parameters incorrectly
• Assuming token is a reserved schema keyword

3. Given the following DynamoDB PutItem request with idempotency token condition:

{
  "TableName": "Orders",
  "Item": {"OrderId": {"S": "123"}, "IdempotencyToken": {"S": "abc-123"}},
  "ConditionExpression": "attribute_not_exists(IdempotencyToken)"
}

What happens if this request is sent twice with the same token?

medium

A. The first request succeeds; the second fails with a conditional check error

B. Both requests succeed and create duplicate items

C. Both requests fail due to token conflict

D. The second request overwrites the first item silently

Solution

1. Step 1: Analyze the condition expression effect

   The condition attribute_not_exists(IdempotencyToken) allows the write only if the token is not present.

2. Step 2: Predict behavior on repeated requests with same token

   The first request writes the item and token. The second request fails because the token now exists, triggering a conditional check failure.

3. Final Answer:

   The first request succeeds; the second fails with a conditional check error -> Option A

4. Quick Check:

   First write OK, second fails condition = D [OK]

Hint: Same token blocks second write with condition failure [OK]

Common Mistakes:

• Assuming both writes succeed causing duplicates
• Thinking second write silently overwrites
• Believing both writes fail

4. You wrote this DynamoDB PutItem request with idempotency token:

{
  "TableName": "Payments",
  "Item": {"PaymentId": {"S": "p001"}, "IdempotencyToken": {"S": "token-xyz"}},
  "ConditionExpression": "attribute_not_exists(IdempotencyToken)"
}

But you get a ConditionalCheckFailedException on the first request. What is the likely cause?

medium

A. An item with the same IdempotencyToken already exists in the table

B. The IdempotencyToken attribute is missing from the item

C. The table does not have a primary key defined

D. The ConditionExpression syntax is invalid

Solution

1. Step 1: Understand the meaning of ConditionalCheckFailedException

   This error means the condition attribute_not_exists(IdempotencyToken) was false, so the token attribute already exists.

2. Step 2: Identify why the first request fails

   If the token already exists in an item, the condition prevents overwriting, causing the failure.

3. Final Answer:

   An item with the same IdempotencyToken already exists in the table -> Option A

4. Quick Check:

   Token exists causes condition failure = A [OK]

Hint: Condition fails if token already exists in table [OK]

Common Mistakes:

• Assuming missing token causes this error
• Thinking primary key absence triggers this error
• Believing condition syntax is wrong

5. You want to design a DynamoDB table to support idempotent order creation using tokens. Which approach best ensures no duplicate orders are created when clients retry requests?

hard

A. Use a composite primary key with OrderId and IdempotencyToken and allow overwrites

B. Use OrderId as the primary key and store IdempotencyToken as a unique attribute with a conditional write checking attribute_not_exists(IdempotencyToken)

C. Use IdempotencyToken as the primary key and reject writes if the token exists

D. Do not store tokens; rely on client-side checks to avoid duplicates

Solution

1. Step 1: Consider uniqueness enforcement for idempotency

   Using IdempotencyToken as the primary key ensures each token is unique and prevents duplicates at the database level.

2. Step 2: Evaluate other options

   Use OrderId as the primary key and store IdempotencyToken as a unique attribute with a conditional write checking attribute_not_exists(IdempotencyToken) risks duplicates if tokens are not primary keys. Use a composite primary key with OrderId and IdempotencyToken and allow overwrites allows overwrites, breaking idempotency. Do not store tokens; rely on client-side checks to avoid duplicates relies on unreliable client checks.

3. Final Answer:

   Use IdempotencyToken as the primary key and reject writes if the token exists -> Option C

4. Quick Check:

   Primary key on token ensures uniqueness = A [OK]

Hint: Make token primary key to enforce uniqueness [OK]

Common Mistakes:

• Storing token as non-key attribute without condition
• Allowing overwrites with composite keys
• Relying only on client-side checks