Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to export dynamoDB table's entire records to CSV from aws console?

I am new to AWS, just working around dynamo DB for first time..

I have a table in dynamoDB with close to 100,000 records in it. I want to export these records to CSV file.

I have tried all possible options in aws console, found that we can only export 100 records at a time, which will not scale well to 100k records,

I did some search around it, exporting to S3 is doable for larger record set.

But I cannot opt that way because of S3 & data pipeline expenses.

Please suggest any work-around (if any).

like image 369
JBourne Avatar asked Nov 17 '17 09:11

JBourne


1 Answers

This application will export the content of a DynamoDB table into CSV (comma-separated values) output. All you need to do is update config.json with your AWS credentials and region.

AWS DynamoDBtoCSV

like image 189
John Hanley Avatar answered Nov 10 '22 08:11

John Hanley