Redshift Unload query generator from SQL statement (warning: trusts input data)

unload.js

#!/usr/bin/env node

const fs = require('fs')

const usage = () => {
  console.log('Usage: unload <aws-arn> <sql-statement-filepath> <name-of-file-in-s3>')
}

if (process.argv.length < 5 || process.argv[2] == '-h') {
  usage()
  process.exit(1)
}

const arn = process.argv[2]
const sqlFilePath = process.argv[3]
const s3FileName = process.argv[4]
const SQL = fs.readFileSync(sqlFilePath)

if (SQL.toString().trim() == '') {
  console.log('Error: SQL file input is empty')
  usage()
}

const unload = `
UNLOAD ('${SQL.toString().replace(/'/g, "\\'")}')
TO 's3://${s3FileName}/' 
IAM_ROLE '${arn}' 
HEADER 
DELIMITER AS ',' 
ALLOWOVERWRITE
MAXFILESIZE AS 5 MB
MANIFEST;
`

console.log(unload)