How to Delete an Item in a DynamoDB Table?

Amazon DynamoDB a fully managed NoSQL database service by Amazon Web Services (AWS), provides simple scalability and high performance for applications of any scale. Managing data in DynamoDB is important sometimes we need to delete specific items from a table to maintain data integrity or changes in our application requirements.

In this article, We will about provide a comprehensive guide on how to delete items in DynamoDB tables using different methods.

DynamoDB – Deleting Items

In DynamoDB, managing data is fundamental and sometimes we may need to remove specific items from a table to maintain data integrity or accommodate changes in our application requirements. We can delete items from DynamoDB tables using different methods used for different purposes.

1. Delete an item Using the Amazon Management Console (GUI)
   
2. Delete an item Using the Amazon CLI (Command Line Interface)

Components Of DynamoDB

• AWS Account: Before starting this tutorial, you must have an AWS account. Read this article in case we don’t have an AWS account.
  
• DynamoDB Table: You must have a table, so we can insert/delete an item from it. If you don’t know how to create the table read this article.

Step-By-Step Guide To Delete Items In AWS

Step 1: Login into AWS

Step 2: After signing-in, We will land on the AWS Management Console page and search for DynamoDB as shown below.

👁 AWS

1. Delete an item Using the Amazon Management Console (GUI)

Step 1: After landing on the DynamboDB dashboard, go to Tables from the sidebar and click on your table name (in my case ‘GeekForGeeks’).

👁 step-11

Step 2: From the Top right go to Explore table items. This will allow us to perform CRUD operations on table.

👁 step-12

Step 3: Select the items desired for deletion, and select Actions | Delete items.

👁 step-13

Step 4: A Delete Items dialog box then appears as shown in the following screeshot. Choose "Delete" to confirm.

👁 step-14

Step 5: After refreshing exploring items page you can see deleted items are removed from tabel.

👁 step-15

2. Delete an item Using the Amazon CLI (Command Line Interface)

Step 1: Select Cloudshell from the bottom left or just Install and Configure AWS CLI on your system.

Syntax:

aws dynamodb delete-item --table-name TABLE-NAME --key '{"PrimaryKeyName": {"DATATYPE": "PrimaryKeyValue"}}'

• TABLE-NAME: add your table name(in my case ‘GeekForGeeks’)
• PrimaryKeyName: add your Primary key name(in my case 'id')
• DATATYPE: In CLI there are different datatype descriptors for each datatype.
  
  • S – String
  • N – Number
  • B – Binary

PrimaryKeyValue: add ypur Primary key values( ex: id:1)

For Example:

aws dynamodb delete-item --table-name GeekForGeeks --key '{"id": {"N": "1"}}'

Best Practices for Deleting Items

• Deleting an item in the DynamoDB only requires providing the table name and the item key. It is also strongly recommended to use of a conditional expression which will be necessary to avoid deleting the wrong items.
  
• Deletes a single item in a table by primary key. You can perform a conditional delete operation that deletes the item if it exists, or if it has an expected attribute value.
  
• In addition to deleting an item, you can also return the item's attribute values in the same operation, using the ReturnValues parameter.

Conclusion

We have successfully deleted some items from the DynamoDB table ('GeekForGeeks') using two methods Amazon Management Console and CloudShell (AWS CLI). Using GUI you can easily delete items by just filling fields but if you want to delete an item from outside Amazon Management Console we can use AWS CLI.