Removes the wide versions of the change log which had dates in the columns which are annoying to maintain because we'll have to update the column names each quarter.
Creates 4 new data mart tables that are snapshots of active projects each quarter for a given geography. This allows users to see the total active capacity for previous years.
Renames iso_regions_change_log and iso_counties_change_log to iso_regions_all_projects_change_log and iso_regions_all_projects_change_log. These tables give users a sense of projects that entered and exited the queue for a given time period and geography. The four new tables just show the total active projects for previous years.
This PR
iso_regions_change_log
andiso_counties_change_log
toiso_regions_all_projects_change_log
andiso_regions_all_projects_change_log
. These tables give users a sense of projects that entered and exited the queue for a given time period and geography. The four new tables just show the total active projects for previous years.