Attribute types (S, N, B, BOOL, L, M) in DynamoDB - Step-by-Step Execution

Concept Flow - Attribute types (S, N, B, BOOL, L, M)

Start with attribute

↓

Check attribute type

↓

S

↓

Store as string

↓

Store as number

↓

Store as binary

↓

Store as boolean

↓

Store as list

↓

Store as map

↓

Reject invalid type

The attribute type is checked and stored accordingly: string (S), number (N), binary (B), boolean (BOOL), list (L), or map (M). Invalid types are rejected.

Execution Sample

DynamoDB

Item = {
  "Name": {"S": "Alice"},
  "Age": {"N": "30"},
  "IsMember": {"BOOL": true},
  "Tags": {"L": [{"S": "VIP"}, {"S": "Premium"}]},
  "Details": {"M": {"Height": {"N": "170"}}}
}

This code defines a DynamoDB item with attributes of different types: string, number, boolean, list, and map.

Execution Table

Step	Attribute	Type Detected	Action	Stored Format
1	Name	S	Store as string	{"S": "Alice"}
2	Age	N	Store as number	{"N": "30"}
3	IsMember	BOOL	Store as boolean	{"BOOL": true}
4	Tags	L	Store as list	{"L": [{"S": "VIP"}, {"S": "Premium"}]}
5	Details	M	Store as map	{"M": {"Height": {"N": "170"}}}
6	UnknownAttr	X	Reject invalid type	Error: Invalid attribute type

💡 All attributes processed; invalid type rejected at step 6.

Variable Tracker

Attribute	Initial	After Step 1	After Step 2	After Step 3	After Step 4	After Step 5	After Step 6
Name	undefined	{"S": "Alice"}	{"S": "Alice"}	{"S": "Alice"}	{"S": "Alice"}	{"S": "Alice"}	{"S": "Alice"}
Age	undefined	undefined	{"N": "30"}	{"N": "30"}	{"N": "30"}	{"N": "30"}	{"N": "30"}
IsMember	undefined	undefined	undefined	{"BOOL": true}	{"BOOL": true}	{"BOOL": true}	{"BOOL": true}
Tags	undefined	undefined	undefined	undefined	{"L": [{"S": "VIP"}, {"S": "Premium"}]}	{"L": [{"S": "VIP"}, {"S": "Premium"}]}	{"L": [{"S": "VIP"}, {"S": "Premium"}]}
Details	undefined	undefined	undefined	undefined	undefined	{"M": {"Height": {"N": "170"}}}	{"M": {"Height": {"N": "170"}}}
UnknownAttr	undefined	undefined	undefined	undefined	undefined	undefined	Error: Invalid attribute type

Key Moments - 3 Insights

Why is the number attribute stored as a string in the 'N' type?

In DynamoDB, numbers are stored as strings to preserve precision and avoid floating-point errors, as shown in execution_table step 2.

What happens if an attribute type is not one of S, N, B, BOOL, L, or M?

The attribute is rejected as invalid, demonstrated in execution_table step 6 where 'UnknownAttr' causes an error.

How are complex data structures like lists and maps stored?

Lists (L) store ordered collections of attributes, and maps (M) store key-value pairs of attributes, as seen in steps 4 and 5.

Visual Quiz - 3 Questions

Look at the execution_table at step 3. What is the stored format of the 'IsMember' attribute?

A {"BOOL": true}

B {"S": "true"}

C {"N": "1"}

D true

💡 Hint

Check the 'Stored Format' column for step 3 in the execution_table.

At which step does the process reject an invalid attribute type?

A Step 2

B Step 4

C Step 6

D Step 5

💡 Hint

Look for the row with 'Reject invalid type' in the 'Action' column.

If the 'Age' attribute was given as {"N": 30} (number, not string), how would the execution_table change?

A Step 2 would store as string with value "30"

B Step 2 would show an error for invalid type

C Step 2 would store as number with value 30

D No change; DynamoDB accepts number type directly

💡 Hint

DynamoDB requires numbers as strings; see step 2 where number is stored as string.

Concept Snapshot

DynamoDB attribute types:
- S: String stored as string
- N: Number stored as string
- B: Binary data
- BOOL: Boolean true/false
- L: List of attributes
- M: Map (key-value pairs)
Invalid types cause errors.
Numbers must be strings to keep precision.

Full Transcript

This visual execution shows how DynamoDB processes attribute types. Each attribute is checked for its type: string (S), number (N), binary (B), boolean (BOOL), list (L), or map (M). The attribute is then stored in the corresponding format. Numbers are stored as strings to avoid precision loss. Lists and maps allow complex nested data. If an attribute type is invalid, it is rejected with an error. The execution table traces each attribute step by step, showing the stored format and actions taken. Variable tracking shows how each attribute's value is set after each step. Key moments clarify common confusions about number storage, invalid types, and complex structures. The quiz tests understanding of stored formats, error detection, and type requirements. The snapshot summarizes the attribute types and key rules for DynamoDB.