Quick script to update all your DynamoDB tables to BillingMode: 'PAY_PER_REQUEST'

update-all-dynamoDB-tables-to-pay-per-request.js

const AWS = require('aws-sdk');
AWS.config.update({ region: 'eu-west-1' });

let dynamoDB = new AWS.DynamoDB();
let allTables = [];
const async = require('async');
const sleep = require('sleep');


function start() {
  getDynamoDbTables({}).then((tables) => {
    async.eachLimit(allTables, 1, updateTable, (error, result) => {
      if(error){
        console.log(error);
        process.exit(1);
      }
      console.log('All Done');
      process.exit(0);
    })
  })
}

function updateTable(TableName, callback) {
  console.log(`Updating.........${TableName}`)
  dynamoDB.updateTable({
    TableName,
    BillingMode: 'PAY_PER_REQUEST'
  }, (error) => {
    if(error){
      console.log(error);
      return callback(error);
    }
    console.log(`${TableName} has been updated`)
    sleep.sleep(10);
    return callback();
  })

}


function getDynamoDbTables(params) {
  return dynamoDB.listTables(params).promise().then((tables) => {
    console.log('Got the current tables', tables)
    allTables = allTables.concat(tables.TableNames);
    if (tables.LastEvaluatedTableName) {
      let params = {
        ExclusiveStartTableName: tables.LastEvaluatedTableName
      }
      return getDynamoDbTables(params);
    }
  })
};

start();