25 lines (17 loc) · 579 Bytes

grover_assignment

exercise 1

create tables in postgres
load csv files to those tables
create fact and dimensions that allow us to generate some end of month reports

where to look at:

etl/etl.py: where the etl happens
sql/exercise1/*: where we have all the ddls and some queries to populate tables
sample_files/*: where the source files are.

exercise 2

query to generate the desired output

where to look at:

sql/exercise2/query.sql

exercise 3

python solution to triangle problem

where to look at:

python_exercise/triangle.py