Skip to content

snarf-snarf-snarf/DynamoDBDeleteAllRows

Repository files navigation

DynamoDB Delete All Rows

Application for deleting all rows from a DynamoDB table. It does this by scanning the table to retrieve the primary key values and then deletes the rows in batches. Currently, AWS limits the maximum batch size to 25, so with large amounts of data multiple requests are executed.

Note: No throttling is currently performed so if you have a lot of data your table capacity will be maxed out and eventually AWS will reject the delete requests. In this scenario just wait a little while and retry. At some point if I get time I might add some code to automatically limit the capacity consumption to avoid this problem.

Prerequisites

You will need to download and install the AWS SDK for .NET.

Useage

First edit the App.config file and change the AWS profile and region as required.

To run the application from a command window:

DynamoDeleteAllRows.exe table_name hash_key_name [range_key_name]

table_name - The name of the DynamoDB table.
hash_key_name - The name of the hash key for the table.
range_key_name - The name of the range key for the table if it has one.