bcgov / cas-ggircs

Climate Action Secretariat's Greenhouse Gas Industrial Reporting and Control System
Apache License 2.0
3 stars 4 forks source link

Metabase alerts for fuel - emission_category assumptions #383

Closed dleard closed 2 years ago

dleard commented 2 years ago

These alerts cannot be created until the latest cas-ggircs release has been deployed to production

The swrs carbon tax calculator makes some assumptions about the data ingested from swrs. These assumptions need to be validated via metabase alerts to let us know if there is a change.

Assumptions: A fuel is only ever associated to one emission category A fuel is never reported without an associated emission category

These assumptions are currently true for all data received beyond the 2011 reporting year.

Acceptance Criteria

matthieu-foucault commented 2 years ago

Looks good to me. For those alerts (we have one for new fuels as well), perhaps we should create functions/views that run the sql command, so that we can test them with pgTap