bbc/DynamoDBtoCSV

Name: DynamoDBtoCSV

Owner: BBC

Description: Dump DynamoDB data into a CSV file

Forked from: edasque/DynamoDBtoCSV

Created: 2017-03-06 10:36:00.0

Updated: 2017-03-17 16:27:12.0

Pushed: 2017-03-06 12:05:33.0

Homepage: null

Size: 19

Language: JavaScript

GitHub Committers

User	Most Recent Commit	# Commits

Other Committers

User	Email	Most Recent Commit	# Commits

README

AWS DynamoDBtoCSV

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.

The output is comma-separated and each field is enclosed by double quotes (“). Double quotes in the data as escaped as "

This software is governed by the Apache 2.0 license.

Usage

typically, to use you'd run:

node dynamoDBtoCSV.js -t Hourly_ZEDO_Impressions_by_IP > output.csv

to export to CSV

Use -d to describe the table prior so you can have an idea of the number of rows you are going to export

node dynamoDBtoCSV.js -t Hourly_ZEDO_Impressions_by_IP -d

to get some information about the table.

Full syntax is:

node dynamoDBtoCSV.js --help
    Usage: dynamoDBtoCSV.js [options]

Options:

    -h, --help               output usage information
    -V, --version            output the version number
    -t, --table [tablename]  Add the table you want to output to csv
    -d, --describe           

Pre-requisites

You'll need to install a few modules, including:

• aws-sdk

• commander

  npm install

should do it.

Example output

"HashOf10","DateIPAdID","adcount"
"37693cfc748049e45d87b8c7d8b9aacd","2013011720024058205168000000010002","1"
"37693cfc748049e45d87b8c7d8b9aacd","2013011720050084232194000000010002","1"