The Amazon DynamoDB Developer Guide uses sample tables to illustrate various aspects of DynamoDB.
Simple primary key:
Simple primary key:
Composite primary key:
Composite primary key:
The Reply table has a global secondary index named PostedBy-Message-Index. This index will facilitate queries on two non-key attributes of the Reply table.
Composite primary key:
For more information about these tables, see Step 1: Create a table and Step 2: Write data to a table.
The following sections show the sample data files that are used for loading the ProductCatalog, Forum, Thread and Reply tables.
Each data file contains multiple PutRequest elements, each of which contain a single item. These PutRequest elements are used as input to the BatchWriteItem operation, using the AWS Command Line Interface (AWS CLI).
"ProductCatalog": [ "PutRequest": "Item": "Id": "N": "101" >, "Title": "S": "Book 101 Title" >, "ISBN": "S": "111-1111111111" >, "Authors": "L": [ "S": "Author1" > ] >, "Price": "N": "2" >, "Dimensions": "S": "8.5 x 11.0 x 0.5" >, "PageCount": "N": "500" >, "InPublication": "BOOL": true >, "ProductCategory": "S": "Book" > > > >, "PutRequest": "Item": "Id": "N": "102" >, "Title": "S": "Book 102 Title" >, "ISBN": "S": "222-2222222222" >, "Authors": "L": [ "S": "Author1" >, "S": "Author2" > ] >, "Price": "N": "20" >, "Dimensions": "S": "8.5 x 11.0 x 0.8" >, "PageCount": "N": "600" >, "InPublication": "BOOL": true >, "ProductCategory": "S": "Book" > > > >, "PutRequest": "Item": "Id": "N": "103" >, "Title": "S": "Book 103 Title" >, "ISBN": "S": "333-3333333333" >, "Authors": "L": [ "S": "Author1" >, "S": "Author2" > ] >, "Price": "N": "2000" >, "Dimensions": "S": "8.5 x 11.0 x 1.5" >, "PageCount": "N": "600" >, "InPublication": "BOOL": false >, "ProductCategory": "S": "Book" > > > >, "PutRequest": "Item": "Id": "N": "201" >, "Title": "S": "18-Bike-201" >, "Description": "S": "201 Description" >, "BicycleType": "S": "Road" >, "Brand": "S": "Mountain A" >, "Price": "N": "100" >, "Color": "L": [ "S": "Red" >, "S": "Black" > ] >, "ProductCategory": "S": "Bicycle" > > > >, "PutRequest": "Item": "Id": "N": "202" >, "Title": "S": "21-Bike-202" >, "Description": "S": "202 Description" >, "BicycleType": "S": "Road" >, "Brand": "S": "Brand-Company A" >, "Price": "N": "200" >, "Color": "L": [ "S": "Green" >, "S": "Black" > ] >, "ProductCategory": "S": "Bicycle" > > > >, "PutRequest": "Item": "Id": "N": "203" >, "Title": "S": "19-Bike-203" >, "Description": "S": "203 Description" >, "BicycleType": "S": "Road" >, "Brand": "S": "Brand-Company B" >, "Price": "N": "300" >, "Color": "L": [ "S": "Red" >, "S": "Green" >, "S": "Black" > ] >, "ProductCategory": "S": "Bicycle" > > > >, "PutRequest": "Item": "Id": "N": "204" >, "Title": "S": "18-Bike-204" >, "Description": "S": "204 Description" >, "BicycleType": "S": "Mountain" >, "Brand": "S": "Brand-Company B" >, "Price": "N": "400" >, "Color": "L": [ "S": "Red" > ] >, "ProductCategory": "S": "Bicycle" > > > >, "PutRequest": "Item": "Id": "N": "205" >, "Title": "S": "18-Bike-204" >, "Description": "S": "205 Description" >, "BicycleType": "S": "Hybrid" >, "Brand": "S": "Brand-Company C" >, "Price": "N": "500" >, "Color": "L": [ "S": "Red" >, "S": "Black" > ] >, "ProductCategory": "S": "Bicycle" > > > > ] > "Forum": [ "PutRequest": "Item": "Name": "S":"Amazon DynamoDB">, "Category": "S":"Amazon Web Services">, "Threads": "N":"2">, "Messages": "N":"4">, "Views": "N":"1000"> > > >, "PutRequest": "Item": "Name": "S":"Amazon S3">, "Category": "S":"Amazon Web Services"> > > > ] > "Thread": [ "PutRequest": "Item": "ForumName": "S": "Amazon DynamoDB" >, "Subject": "S": "DynamoDB Thread 1" >, "Message": "S": "DynamoDB thread 1 message" >, "LastPostedBy": "S": "User A" >, "LastPostedDateTime": "S": "2015-09-22T19:58:22.514Z" >, "Views": "N": "0" >, "Replies": "N": "0" >, "Answered": "N": "0" >, "Tags": "L": [ "S": "index" >, "S": "primarykey" >, "S": "table" > ] > > > >, "PutRequest": "Item": "ForumName": "S": "Amazon DynamoDB" >, "Subject": "S": "DynamoDB Thread 2" >, "Message": "S": "DynamoDB thread 2 message" >, "LastPostedBy": "S": "User A" >, "LastPostedDateTime": "S": "2015-09-15T19:58:22.514Z" >, "Views": "N": "3" >, "Replies": "N": "0" >, "Answered": "N": "0" >, "Tags": "L": [ "S": "items" >, "S": "attributes" >, "S": "throughput" > ] > > > >, "PutRequest": "Item": "ForumName": "S": "Amazon S3" >, "Subject": "S": "S3 Thread 1" >, "Message": "S": "S3 thread 1 message" >, "LastPostedBy": "S": "User A" >, "LastPostedDateTime": "S": "2015-09-29T19:58:22.514Z" >, "Views": "N": "0" >, "Replies": "N": "0" >, "Answered": "N": "0" >, "Tags": "L": [ "S": "largeobjects" >, "S": "multipart upload" > ] > > > > ] > "Reply": [ "PutRequest": "Item": "Id": "S": "Amazon DynamoDB#DynamoDB Thread 1" >, "ReplyDateTime": "S": "2015-09-15T19:58:22.947Z" >, "Message": "S": "DynamoDB Thread 1 Reply 1 text" >, "PostedBy": "S": "User A" > > > >, "PutRequest": "Item": "Id": "S": "Amazon DynamoDB#DynamoDB Thread 1" >, "ReplyDateTime": "S": "2015-09-22T19:58:22.947Z" >, "Message": "S": "DynamoDB Thread 1 Reply 2 text" >, "PostedBy": "S": "User B" > > > >, "PutRequest": "Item": "Id": "S": "Amazon DynamoDB#DynamoDB Thread 2" >, "ReplyDateTime": "S": "2015-09-29T19:58:22.947Z" >, "Message": "S": "DynamoDB Thread 2 Reply 1 text" >, "PostedBy": "S": "User A" > > > >, "PutRequest": "Item": "Id": "S": "Amazon DynamoDB#DynamoDB Thread 2" >, "ReplyDateTime": "S": "2015-10-05T19:58:22.947Z" >, "Message": "S": "DynamoDB Thread 2 Reply 2 text" >, "PostedBy": "S": "User A" > > > > ] >