Eventually I'd like this to be a quick, general purpose tool for when I want to use SQL on data that can be easily exported to a CSV file. Right now it just does slack member metrics.
Entry point is ./start. Running this script will:
- Pull down dependencies
- Stand up a postgres database container
- Populate it from the CSV
- Tell you how to connect to it
- Stand up a sqlpad container for convenience
- Docker
- Nodejs
- Browse to Slack Analytics and view Members:
https://<YOUR ORG>.slack.com/stats#members
- "Edit columns" -> "Select all" -> "Close"
- Set the date range you're interested in
- "Export CSV"
- Slackbot will DM you the CSV when it's ready
- Replace input.csv with the thing you just downloaded
- run
./start
- Script will print a few ways to access data
Alternatively, run the script as is with the sample input and then run just the parsing script passing your CSV as an argument, e.g. ./start && node index.js the-csv-i-downloaded.csv