Skip to content

Latest commit

 

History

History
22 lines (15 loc) · 514 Bytes

README.md

File metadata and controls

22 lines (15 loc) · 514 Bytes
  1. Create a postgres database called 'cost' and give yourself access, eg
$ su - postgres
postgres@bacon:~$ psql
postgres=# create database cost;
CREATE DATABASE
postgres=# GRANT ALL PRIVILEGES ON DATABASE cost to <USERNAME>;
GRANT
  1. Download report from Billing

    a) => Cost Table => Table configuration (Select No Grouping)

    b) Download and copy/move to raw_billing_csvs/ folder

  2. ./run.sh

  3. psql cost < queries.sql

The queries can be adjusted for your particular needs in analysis.