Purging data from DynamoDB

0

I loaded a massive database but now I need to purge the data so I can retest my load process. Currently I am dropping g the table and the-adding it but this takes time. Is the a better way to handle?

Awsdev
gefragt vor 8 Monaten258 Aufrufe
1 Antwort
1
Akzeptierte Antwort

The best way to delete data is to utilize the time to live (TTL) feature in dynamoDB. Once enabled at the table level, you specify a field to hold the numeric value to expire the data. This numeric field is the epoch date time. Once this date time is in the past, AWS (within a day or so) will automatically remove this data (at no extra charge). With this in place, you will not need to drop and rebuild the table, but you will need to manage this TTL attribute.

Another option is to use infrastructure as code (such as CDK, CloudFormation templates, etc), to rename this table which will drop and establish a new table.

profile picture
beantwortet vor 8 Monaten
profile pictureAWS
EXPERTE
überprüft vor 8 Monaten
profile pictureAWS
EXPERTE
überprüft vor 8 Monaten
  • Thank you sir! Ttl is exactly what I needed

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen