1BI22CS011 Cloud Computing Lab
PROGRAM 3: Working with Amazon DynamoDB which makes use of PartiQL.
Steps for creation of Table.
Step 1: Login to your AWS account. Search for DynamoDB. Click on “Create a table”.
Step 2: Enter name “student-details” and primary key “USN”, “String” type.
Dept. of CSE, BIT 2024-2025 1
1BI22CS011 Cloud Computing Lab
Step 3: Click on “Customize settings” under “Table Settings” and “DynamoDB Standard-
1A” under “Table Class”.
Step 4: Click on “Create table”.
Dept. of CSE, BIT 2024-2025 2
1BI22CS011 Cloud Computing Lab
Steps for creation of an Item.
Step 1: Navigate within the table (via hyperlink of the table) and select “Explore Table
Items”.
Dept. of CSE, BIT 2024-2025 3
1BI22CS011 Cloud Computing Lab
Step 2: Click on “Create Item”.
Step 3: Click on “Add Attributes” and select “String”, and name the attribute “NAME”. Do
the same for the following attributes:
DEPT - String, SEM - Number, SEC - String, BATCH - Number, and enter values for the
same. Press “Create Item”, the item is added successfully to the table.
Dept. of CSE, BIT 2024-2025 4
1BI22CS011 Cloud Computing Lab
Step 4: Click on “JSON View”. Enter the attributes with datatype and a value. Create item.
Dept. of CSE, BIT 2024-2025 5
1BI22CS011 Cloud Computing Lab
Step 5: Similarly, add the rest of the data.
Steps for creation of a Query.
Step 1: On the left side panel select “PartiQL Editor”. Corresponding to the “student-details”
table, click on the 3 dots.
Dept. of CSE, BIT 2024-2025 6
1BI22CS011 Cloud Computing Lab
Step 2: Select “Scan table”, the pre-built query appears, upon pressing “Run”, the query is
executed. Output shows all the items present in the table. Clear the query before running a
new one.
Dept. of CSE, BIT 2024-2025 7
1BI22CS011 Cloud Computing Lab
Step 3: Select “Query table”, the pre-built query appears, upon pressing “Run”, the query is
executed. Output shows the specified item from the table.
Dept. of CSE, BIT 2024-2025 8
1BI22CS011 Cloud Computing Lab
Step 4: Select “Set table”, the pre-built query appears, upon pressing “Run”, the query is
executed. Output executed will include changes made to an attribute of an item, based on the
primary key. (Here, USN “1BI22CS029”, section is set to “A”, it was initially “B”).
Dept. of CSE, BIT 2024-2025 9
1BI22CS011 Cloud Computing Lab
Step 5: Select “Scan table”, the pre-built query appears, upon pressing “Run”, the query is
executed. Output shows all the items present in the table. To observe the previously made
changes.
Step 6: Select “Drop Item”, the pre-built query appears, upon pressing “Run”, the query is
executed.
Dept. of CSE, BIT 2024-2025 10
1BI22CS011 Cloud Computing Lab
STEP 7:Output drops/ deletes the specified item from the table. (USN “1BI22EC008”, is
dropped)
Step 8: Select “Scan table”, the pre-built query appears, upon pressing “Run”, the query is
executed. Output shows all the items present in the table. To observe the previously made
changes. (Currently only 3 items will remain)
Dept. of CSE, BIT 2024-2025 11
1BI22CS011 Cloud Computing Lab
Step 9: Delete the table, by selecting the table and pressing on the “delete” button. Confirm
the same.
Step 10: Successfully deleted notified
Dept. of CSE, BIT 2024-2025 12