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

bcgov / cas-metabase

Metabase helm chart

Apache License 2.0

1 stars 2 forks source link

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

Open Dianadec opened 3 years ago

Dianadec commented 3 years ago

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 commented 3 years ago

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 commented 3 years ago

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.