Importing CSV to DynamoDB table

index.js

const fs = require('fs')
const parse = require('csv-parse/lib/sync')
const AWS = require('aws-sdk')

var credentials = new AWS.SharedIniFileCredentials({ profile: '<aws-profile>' });

AWS.config.update({
  region: 'ap-southeast-1',
  credentials: credentials
});

const docClient = new AWS.DynamoDB.DocumentClient()

const contents = fs.readFileSync('./selected.csv', 'utf-8')

// If you made an export of a DynamoDB table you need to remove (S) etc from header
const data = parse(contents, { columns: true })

data.forEach((item) => {
  if (!item.maybeempty) delete item.maybeempty // need to remove empty items
  item.version = parseInt(1) // added this since my table has sort key

  docClient.put({
    TableName: '<table-name>',
    Item: item
  }, (err, res) => {
    if (err) console.log(err)
    console.log(`Inserting ${item.name}`)
  })
})

package.json

{
  "name": "dydbimport",
  "version": "1.0.0",
  "main": "index.js",
  "license": "MIT",
  "dependencies": {
    "aws-sdk": "^2.153.0",
    "csv-parse": "^2.0.0"
  }
}

Install Package using:

npm install

Run the app using

node index.js