TTL attribute setup in DynamoDB - Step-by-Step Execution

Concept Flow - TTL attribute setup

Enable TTL on Table

↓

Specify TTL Attribute Name

↓

DynamoDB Monitors TTL Attribute

↓

Item TTL Timestamp Reached?

No→Wait

Yes↓

DynamoDB Deletes Expired Item

↓

Item Removed from Table

This flow shows how enabling TTL on a DynamoDB table works: you enable TTL, specify the attribute holding expiration time, DynamoDB checks items, and deletes expired ones automatically.

Execution Sample

DynamoDB

aws dynamodb update-time-to-live \
  --table-name MyTable \
  --time-to-live-specification Enabled=true,AttributeName=expireAt

This command enables TTL on 'MyTable' using the attribute 'expireAt' to store expiration timestamps.

Execution Table

Step	Action	TTL Attribute Present?	TTL Timestamp Value	TTL Expired?	Result
1	Enable TTL on table with attribute 'expireAt'	N/A	N/A	N/A	TTL enabled, monitoring starts
2	Insert item with expireAt=1700000000	Yes	1700000000	No (current time < 1700000000)	Item stored, not deleted
3	Insert item without expireAt attribute	No	N/A	N/A	Item stored, TTL ignored
4	Current time reaches 1700000000	Yes	1700000000	Yes	Item deleted automatically
5	Check item without expireAt	No	N/A	N/A	Item remains, no TTL applied

💡 TTL deletes items only when current time >= TTL attribute timestamp; items without TTL attribute remain.

Variable Tracker

Variable	Start	After Step 2	After Step 3	After Step 4	Final
TTL Enabled	false	true	true	true	true
Item1 expireAt	N/A	1700000000	1700000000	deleted	deleted
Item2 expireAt	N/A	N/A	N/A	N/A	exists

Key Moments - 2 Insights

Why doesn't DynamoDB delete items without the TTL attribute?

Because TTL only works on items that have the specified TTL attribute. As shown in execution_table row 3 and 5, items without 'expireAt' are ignored by TTL.

When exactly does DynamoDB delete an item based on TTL?

DynamoDB deletes an item only when the current time is equal or greater than the TTL timestamp in the attribute, as shown in execution_table row 4.

Visual Quiz - 3 Questions

Look at the execution_table, what is the TTL Enabled state after step 2?

A unknown

B false

C true

D not set

💡 Hint

Check variable_tracker row 'TTL Enabled' after step 2

At which step does DynamoDB delete an item due to TTL expiration?

A Step 4

B Step 3

C Step 2

D Step 5

💡 Hint

See execution_table row where 'Result' says 'Item deleted automatically'

If an item has no TTL attribute, what happens to it according to the execution_table?

A It is deleted immediately

B It remains in the table

C It is deleted after some time

D It causes an error

💡 Hint

Look at rows 3 and 5 in execution_table where TTL attribute is missing

Concept Snapshot

Enable TTL on a DynamoDB table by specifying an attribute name.
This attribute holds a Unix epoch timestamp (in seconds) for expiration.
DynamoDB automatically deletes items when current time >= TTL value.
Items without the TTL attribute are not affected.
TTL helps clean up expired data without manual deletion.

Full Transcript

This visual execution trace shows how TTL attribute setup works in DynamoDB. First, TTL is enabled on a table with a chosen attribute name, for example 'expireAt'. When items are inserted, if they have this attribute with a timestamp in the future, they remain stored. If the timestamp is reached or passed, DynamoDB automatically deletes the item. Items without the TTL attribute are ignored by TTL and stay in the table. The execution table walks through enabling TTL, inserting items with and without TTL attribute, and the automatic deletion process when the TTL expires. The variable tracker shows the TTL enabled state and item attribute values changing over steps. Key moments clarify why items without TTL attribute are not deleted and when deletion happens. The quiz tests understanding of TTL enabled state, deletion timing, and behavior for items missing TTL attribute. The snapshot summarizes the TTL setup and behavior simply.

Practice

1. What is the main purpose of setting a TTL attribute in a DynamoDB table?

easy

A. To increase the read capacity of the table

B. To encrypt data stored in the table

C. To create backups of the table data

D. To automatically delete expired items based on a timestamp

Solution

1. Step 1: Understand TTL functionality

   TTL (Time To Live) is used to automatically remove items after a certain time.

2. Step 2: Identify the purpose in DynamoDB context

   In DynamoDB, TTL deletes expired items to save storage and cost.

3. Final Answer:

   To automatically delete expired items based on a timestamp -> Option D

4. Quick Check:

   TTL = auto-delete expired items [OK]

Hint: TTL means auto-delete expired data by timestamp [OK]

Common Mistakes:

• Confusing TTL with encryption
• Thinking TTL increases capacity
• Assuming TTL creates backups

2. Which of the following is the correct way to specify the TTL attribute in DynamoDB?

easy

A. Set a numeric attribute with Unix epoch time in seconds

B. Set a list attribute with expiration dates

C. Set a boolean attribute to true when item expires

D. Set a string attribute with date format 'YYYY-MM-DD'

Solution

1. Step 1: Recall TTL attribute data type

   DynamoDB TTL requires a numeric attribute representing Unix epoch time in seconds.

2. Step 2: Evaluate options

   Only Set a numeric attribute with Unix epoch time in seconds correctly uses numeric Unix epoch seconds for TTL.

3. Final Answer:

   Set a numeric attribute with Unix epoch time in seconds -> Option A

4. Quick Check:

   TTL attribute = numeric Unix epoch seconds [OK]

Hint: TTL attribute must be numeric Unix epoch seconds [OK]

Common Mistakes:

• Using string date formats instead of numeric
• Using boolean or list types for TTL
• Not enabling TTL on the table after setting attribute

3. Given a DynamoDB item with attribute expireAt set to 1700000000 (Unix epoch seconds), and TTL enabled on expireAt, what happens when the current time is 1700000001?

medium

A. The item remains until manually deleted

B. The item is automatically deleted by DynamoDB

C. The item is archived automatically

D. The item is updated with a new TTL value

Solution

1. Step 1: Understand TTL expiration behavior

   When current time exceeds the TTL timestamp, DynamoDB marks the item for deletion.

2. Step 2: Apply to given timestamp

   Since current time 1700000001 > expireAt 1700000000, item is deleted automatically.

3. Final Answer:

   The item is automatically deleted by DynamoDB -> Option B

4. Quick Check:

   Current time > TTL timestamp = item deleted [OK]

Hint: Item deletes when current time passes TTL timestamp [OK]

Common Mistakes:

• Thinking item stays until manual deletion
• Assuming item is archived instead of deleted
• Believing TTL updates item automatically

4. You set the TTL attribute to a string value like "2024-12-31" and enabled TTL on that attribute. What issue will you face?

medium

A. TTL will not delete expired items because attribute is not numeric

B. DynamoDB will throw a syntax error on enabling TTL

C. Items will be deleted immediately regardless of date

D. TTL will convert string to numeric automatically

Solution

1. Step 1: Check TTL attribute type requirement

   TTL attribute must be numeric Unix epoch seconds, not string.

2. Step 2: Analyze effect of string value

   DynamoDB ignores TTL deletion if attribute is not numeric, so items won't expire.

3. Final Answer:

   TTL will not delete expired items because attribute is not numeric -> Option A

4. Quick Check:

   Non-numeric TTL attribute = no deletion [OK]

Hint: TTL attribute must be numeric; strings cause no deletion [OK]

Common Mistakes:

• Expecting DynamoDB to error on TTL enable
• Assuming immediate deletion with wrong type
• Believing automatic type conversion happens

5. You want to set up TTL on a DynamoDB table to delete items 7 days after creation. Which approach correctly sets the TTL attribute expireAt when inserting an item?

hard

A. Set expireAt to a boolean true after 7 days

B. Set expireAt to current date string plus 7 days in 'YYYY-MM-DD' format

C. Set expireAt to current Unix epoch seconds plus 604800 (7 days in seconds)

D. Set expireAt to the current Unix epoch seconds without adding days

Solution

1. Step 1: Calculate TTL timestamp for 7 days later

   7 days = 7 * 24 * 60 * 60 = 604800 seconds; add to current Unix epoch seconds.

2. Step 2: Set TTL attribute correctly

   Assign expireAt the numeric value of current time + 604800 seconds for proper TTL.

3. Final Answer:

   Set expireAt to current Unix epoch seconds plus 604800 (7 days in seconds) -> Option C

4. Quick Check:

   TTL timestamp = now + 7 days in seconds [OK]

Hint: Add 604800 seconds to now for 7-day TTL [OK]

Common Mistakes:

• Using date strings instead of numeric timestamps
• Setting TTL to current time without delay
• Using boolean or other types for TTL