How-To Delete All DynamoDB Items (Without Deleting the Table)

Prerequisite:   Download Dynobase (free to try) in order to follow the steps below
Select Truncate

Right-click on the table you want to empty and click on Truncate

Type table name to confirm

Confirm truncate by retyping the table name and then click on 'Truncate'

Check empty table

Once the process is complete, perform a scan once again to see that the data has been removed from the table.

Frequently Asked Questions

How does DynamoDB truncate functionality work in Dynobase?

There's no simple way to truncate the whole table like in the SQL world. Dynobase scans your whole table, paginated through the results and deletes each record one by one.

Are there any other ways to delete all items in DynamoDB table?

Yes. However, AWS Console does not offer this functionality. Alternatively, you can write a custom script to achieve the same thing or delete the table and remove it.

What is the disadvantage of deleting table vs deleting all items in DynamoDB?

Deleting a DynamoDB table would result in you losing many other settings and associations with other AWS Services. Moreover, it might violate immutability of your stack when using e.g. Terraform, and cause drifts when using CloudFormation or CDK

How fast is the DynamoDB clear table functionality?

It depends on two things: The amount of items in your table (faster if fewer) and provisioned read & write capacity (the more, the faster). It works best for small tables with less than 1 million records. In majority of cases, truncation process is completed within one minute.

Is it free to purge and empty a DynamoDB table?

Unfortunately - no. Because Dynobase scans the whole table and performs a write operation against each record, you're going to be charged for that. More on that in the Pricing Calcualtor

Easy way to truncate table in DynamoDB

Dynobase is a professional GUI editor for DynamoDB. Currently, AWS DynamoDB Console does not offer the ability to purge data from a table. You can delete the table and re-create it from scratch or scan through all items and delete all of them one by one. With Dynobase, it's easy and fast.

Product Features

Member Portal
© 2024 Dynobase