How-To Delete All DynamoDB Items (Without Deleting the Table)
Right-click on the table you want to empty and click on Truncate
Confirm truncate by retyping the table name and then click on 'Truncate Table'
Once the process is complete, hit Execute or CMD/CTRL + R to live data 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 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 v/s 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
How fast is the DynamoDB clear table functionality?
It depends on two things: The amount of items in your table (faster if less) and provisioned write capacity (faster if more). It works best for small tables with less than 1 million records.
Is it free to purge and empty a DynamoDB table?
Unfortunately - no. Because Dynobase scans the whole table and performs a Put operation against each record, you're going to be charged for that.
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.
© 2020 Dynobase