INVESTIGATE: As a developer, I want to create a data warehouse solution for the industrial ghg data that is compatible with Metabase and OCP

[Dianadec]

About keeping the ciip/swrs data together and viewable in metabase once we stop doing a pgdump from swrs to ciip & move to an api or foreign data wrapper solution

Checklist:

• set up Dev meeting to discuss possible approaches
• identify possible risks/impacts
• set up database with limited data to test?

[Dianadec]

As discussed during release planning this morning, this one needs to happen before the CIF product development. Tagging as refinement and attn: developer @LindsayMacfarlane @matthieu-foucault

[LindsayMacfarlane]

Backlog refinement (September 22, 2021): this is really a full on EPIC and a lot of work. If we want to be able to compare information/query information, data/info should be in the same database. This needs to be discussed further and may require some experimentation. May impact Metabase questions.