Best way to retrieve all data in DynamoDB table and subsequently clear the table

Question

I am interested in receiving all the data located in my DynamoDB table and most efficiently clear the table afterwards.

I have seen how to delete an item and retrieve it concurrently in concurrency - DynamoDB - how to retrieve and delete (pop) an item?. I have also seen batch deletion in database - What is the recommended way to delete a large number of items from DynamoDB?.

Ideally I would like to concurrently clear the table and retrieve the data. Is there a better way to do this?

Answer 1

If you subscribe a lambda function to the dynamo db stream for the table, you can process items as they are deleted (technically, it will show up in the stream shortly after the item is deleted).

Answer 2

You could retrieve all rows from the table, put it in a list and then send the list to dynamodbs delete method. This works for me:

 public async Task DeleteAllReadModelEntitiesInTable()
{
    List<ReadModelEntity> readModels;

    var conditions = new List<ScanCondition>();
    readModels = await _context.ScanAsync<ReadModelEntity>(conditions).GetRemainingAsync();

    var batchWork = _context.CreateBatchWrite<ReadModelEntity>();
    batchWork.AddDeleteItems(readModels);
    await batchWork.ExecuteAsync();
}