How to export DynamoDB table data without the point in time recovery?

0
votes

I am trying to export data from a DynamoDB table for the last 15 days, but unfortunately, the point in time recovery is not active. So I can't use the new DynamoDB export to S3 feature because it's not retroactive.

I have tried using the AWS Data Pipeline to export the DynamoDB data to S3 but is it retroactive?

If so I have tried to export the data but the Pipeline is failing with the TableBackupActivity with a status of cancelled. Didn't find anything in the log bucket nor in the Data Pipeline console but only this

@failureReason Resource not healthy: Jobflow retired

How to know if this is due to the Read Capacity Unit of the DynamoDB Table?

1
amazon-dynamodbamazon-emramazon-data-pipeline
So you want to export data that you don't have, because you haven't enabled point in time recovery? Unless you have enabled DynamoDB streams and continuously write the changes somewhere (which seems unlikely) you're probably out of luck :/ – Maurice

1 Answers

0
votes

You cannot backup data to s3 natively without the Point in time Recovery enabled.

Another way of doing this would be reading the complete database and saving it as JSON. And during the time of recovery re-populating your disaster recovery database with your JSON file. Amazon has an article for populating dynamodb from JSON file here https://aws.amazon.com/blogs/compute/creating-a-scalable-serverless-import-process-for-amazon-dynamodb/