This repo contains all the table creation and modification/cleaning code for our data mart.
CreateTables.sql contains all code related to table creation.
FormatWorldBankData.js has a script written for Google sheets to convert raw CSV data from the World Bank to CSV data that can be imported into a postgresql database.
DateDimension.sql contains code used to create the table as well as the code to populate the table.
Table_Cleaning.ipnyp contains code used to determine which columns to drop from dataset and what to do about missing values.
FactTable.sql contains code for fact table creation and importing data.