CODEWITHSUNDEEP
amazon-dynamodbaws-lambdaamazon-redshiftnosql
Prasad Pande
Prasad Pande

Reputation: 508

Purging technique for Dynamodb

I am a newbie in Amazon Dynamodb world with strong background from relation database world :-p

I am writing a service using AWS lambda functionality that migrates the data from dynamodb to RedShift for analytics purpose. My aim is to keep only active data of say 1 month in dynamodb and then purge it periodically.

I researched a lot but could not find a precise purging technique for Amazon dynamodb that will avoid full table scan.

Also, I want to perform delete based on the Range key attribute which is a timestamp attribute.

Can somebody help me out here?

Thanks

Upvotes: 0

Views: 970

Answers (1)

Chen Harel
Chen Harel

Reputation: 10062

From my experience the easiest and most cost-effective way to handle this job is to create a new table each month, and remove complete old tables when time passes and you are done crunching them.

If you can make your use case use a TABLE-MMYYYY it would help you a lot.

Upvotes: 1

Related Questions