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

csv amazon-web-services amazon-dynamodb export-to-csv
JBourne picture JBourne · Nov 17, 2017 · Viewed 16k times · Source

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).

Answer

John Hanley picture John Hanley · Nov 17, 2017

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

Related questions

How can I import bulk data from a CSV file into DynamoDB?

I am trying to import a CSV file data into AWS DynamoDB. Here's what my CSV file looks like: first_name last_name sri ram Rahul Dravid JetPay Underwriter Anil Kumar Gurram

Read More
How to export a dynamodb table as a csv through aws-cli ( without using pipeline)

I am new to aws-cli and I am trying to export my dynamodb table as a csv so that i can import it directly into postgresql. Is there a way to do that using aws-cli ? So far i have came …

Read More
Hadoop/Hive : Loading data from .csv on a local machine

As this is coming from a newbie... I had Hadoop and Hive set up for me, so I can run Hive queries on my computer accessing data on AWS cluster. Can I run Hive queries with .csv data stored on …

Read More