dynobase-icon
Dynobase

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

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

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

2
Type table name to confirm

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

3
Check empty 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.

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

© 2020 Dynobase