At this step, we take the cleaned data for the year to be studied and store them within the staging Postgres database. Some relationships between this tables are defined to force the integrity of the data between the 3 tables (etablissements, emissions and rejets). It is possible to define the studied year using the STUDIED_YEAR parameter within the constants.py file.
At this step, we take the cleaned data for the year to be studied and store them within the staging Postgres database. Some relationships between this tables are defined to force the integrity of the data between the 3 tables (etablissements, emissions and rejets). It is possible to define the studied year using the STUDIED_YEAR parameter within the constants.py file.