medic/cht-pipeline issues and pull requests

#181 - feat: add users meta base models

Pull Request - State: open - Opened by njuguna-n 14 days ago

#180 - Add users meta base models

Issue - State: open - Opened by 1yuv about 1 month ago - 4 comments
Labels: Type: Improvement

#179 - chore: update readme with docs site link and PR template

Pull Request - State: closed - Opened by andrablaj about 1 month ago

#178 - chore: enable SQL checks in Sonar

Pull Request - State: closed - Opened by andrablaj about 2 months ago - 1 comment

#177 - fix(#176): use python 3.12

Pull Request - State: closed - Opened by andrablaj about 2 months ago - 1 comment
Labels: released

#176 - CI fails when using Python 3.13

Issue - State: closed - Opened by andrablaj about 2 months ago - 2 comments
Labels: Type: Bug, released

#175 - chore: add .idea to .gitignore

Pull Request - State: closed - Opened by andrablaj about 2 months ago - 4 comments

#174 - feat: run dbt in batches for document_metadata model

Pull Request - State: open - Opened by njuguna-n about 2 months ago

#173 - feat: remove date_of_birth column from person model

Pull Request - State: closed - Opened by njuguna-n 2 months ago - 1 comment
Labels: released

#172 - chore(#165): create custom generic test to assert date format

Pull Request - State: closed - Opened by lorerod 2 months ago - 1 comment

#171 - fix: add extra validation to date format

Pull Request - State: closed - Opened by njuguna-n 2 months ago - 1 comment
Labels: released

#170 - fix(#165): removing potentially ambiguous date format

Pull Request - State: closed - Opened by witash 2 months ago - 2 comments
Labels: released

#169 - fix: remove unused macro

Pull Request - State: closed - Opened by njuguna-n 2 months ago - 1 comment
Labels: released

#168 - Add tasks and targets to base models

Issue - State: open - Opened by witash 2 months ago
Labels: Type: Improvement

#167 - fix: date casting in person model

Pull Request - State: closed - Opened by njuguna-n 2 months ago - 1 comment
Labels: released

#166 - Handle different date formats in the person model

Issue - State: closed - Opened by njuguna-n 2 months ago - 1 comment
Labels: Type: Bug, Won't fix: Duplicate

#165 - improperly formatted dates can cause models to fail

Issue - State: closed - Opened by witash 2 months ago - 18 comments
Labels: Type: Bug

#164 - fix: fail builds if dbt run fails

Pull Request - State: closed - Opened by njuguna-n 2 months ago - 2 comments
Labels: released

#163 - fix: handle empty strings, bull values, and incorrect dates for date_…

Pull Request - State: closed - Opened by njuguna-n 3 months ago - 1 comment

#162 - Handle empty dates in the person model

Issue - State: closed - Opened by njuguna-n 3 months ago
Labels: Type: Bug

#161 - chore: remove branding from readme

Pull Request - State: closed - Opened by garethbowen 3 months ago - 2 comments
Labels: released

#160 - chore: add Github issue templates

Pull Request - State: closed - Opened by njuguna-n 3 months ago - 1 comment
Labels: released

#159 - Add issue template files

Issue - State: closed - Opened by njuguna-n 3 months ago

#158 - fix(#156): unit test fixture not found when integrating with cht-sync

Pull Request - State: closed - Opened by lorerod 3 months ago - 1 comment
Labels: released

#157 - feat: update postgres version

Pull Request - State: closed - Opened by njuguna-n 3 months ago - 1 comment
Labels: released

#156 - Unit test fixtures not found when integrating with cht-sync

Issue - State: closed - Opened by njuguna-n 3 months ago - 6 comments
Labels: Type: Bug, released

#155 - feat(#144): add macros to reduce boilerplate

Pull Request - State: closed - Opened by witash 3 months ago - 4 comments
Labels: released

#154 - Debug macros not executing in dbt testing environment

Issue - State: open - Opened by lorerod 3 months ago - 2 comments

#153 - Document permissions required to use fine-grained personal access tokens from Github

Issue - State: closed - Opened by njuguna-n 3 months ago - 2 comments
Labels: Type: Documentation

#152 - feat(#148): add automatic releases and versioning

Pull Request - State: closed - Opened by njuguna-n 3 months ago - 3 comments
Labels: released

#151 - chore(#79): enhance dbt model testing

Pull Request - State: closed - Opened by lorerod 3 months ago - 2 comments
Labels: released

#150 - Document how to test project specific DBT models

Issue - State: closed - Opened by njuguna-n 3 months ago - 3 comments
Labels: Type: Documentation

#149 - Document a way to store Superset Dashboard queries

Issue - State: closed - Opened by njuguna-n 3 months ago - 2 comments
Labels: Type: Documentation

#148 - Add automatic releases and versioning

Issue - State: closed - Opened by njuguna-n 3 months ago - 1 comment
Labels: Type: Improvement

#147 - Build should fail if models are not all building properly

Issue - State: closed - Opened by njuguna-n 3 months ago - 1 comment
Labels: released

#146 - fix(#145): docker compose instead of docker-compose

Pull Request - State: closed - Opened by witash 4 months ago - 1 comment
Labels: released

#145 - test script uses docker-compose instead of docker compose

Issue - State: closed - Opened by witash 4 months ago - 1 comment
Labels: released

#144 - Add macros to reduce boilerplate in downstream projects

Issue - State: closed - Opened by witash 4 months ago - 1 comment
Labels: Priority: 2 - Medium, released

#143 - 141 handle contact and data record deletes with root

Pull Request - State: closed - Opened by witash 4 months ago - 1 comment
Labels: released

#142 - feat: handle deleted docs in contact and data_record models

Pull Request - State: closed - Opened by njuguna-n 4 months ago - 1 comment

#141 - Handle document deletes in the contact and data_record models

Issue - State: closed - Opened by njuguna-n 4 months ago - 1 comment

#140 - 96 add run stats to db

Pull Request - State: closed - Opened by witash 4 months ago - 1 comment
Labels: released

#139 - Add root model back to dbt

Issue - State: closed - Opened by witash 4 months ago - 1 comment
Labels: Priority: 1 - High

#101 - test: add DBT tests

Pull Request - State: closed - Opened by njuguna-n 5 months ago - 1 comment

#100 - Test and document performance differences of using an autoincrementeing integer vs a uuid as the primary key

Issue - State: open - Opened by njuguna-n 5 months ago - 1 comment
Labels: Type: Performance

#99 - 98 rename @timestamp column

Pull Request - State: closed - Opened by njuguna-n 5 months ago - 1 comment

#98 - Rename @timestamp column

Issue - State: closed - Opened by njuguna-n 5 months ago - 2 comments

#97 - 90 base models

Pull Request - State: closed - Opened by njuguna-n 6 months ago - 10 comments
Labels: released

#96 - Benchmark DBT model performance with expected MoH KE traffic and real world models

Issue - State: closed - Opened by njuguna-n 6 months ago - 2 comments
Labels: Priority: 1 - High

#95 - chore: Add PR template

Pull Request - State: closed - Opened by andrablaj 6 months ago - 1 comment
Labels: released

#95 - chore: Add PR template

Pull Request - State: closed - Opened by andrablaj 6 months ago - 1 comment
Labels: released

#94 - 90 base models

Pull Request - State: closed - Opened by njuguna-n 6 months ago - 5 comments

#93 - 90 base models

Pull Request - State: closed - Opened by njuguna-n 6 months ago

#92 - DBT failures on first run

Issue - State: closed - Opened by njuguna-n 6 months ago - 2 comments

#91 - 87 fix max timestamp macros

Pull Request - State: closed - Opened by njuguna-n 6 months ago

#90 - Create base models for CHT

Issue - State: closed - Opened by andrablaj 6 months ago - 7 comments
Labels: Priority: 1 - High

#88 - BRAC models

Pull Request - State: closed - Opened by njuguna-n 6 months ago

#87 - Using the max_existing_timestamp macros on a new table throws an error

Issue - State: closed - Opened by njuguna-n 6 months ago - 3 comments
Labels: Type: Bug

#86 - chore(#85): Add Sonar configuration

Pull Request - State: closed - Opened by andrablaj 6 months ago - 1 comment
Labels: released

#85 - Add SonarCloud configuration

Issue - State: closed - Opened by andrablaj 6 months ago - 1 comment
Labels: Type: Technical issue, released

#84 - Don't use a `couchdb` materialized view

Issue - State: closed - Opened by dianabarsan 6 months ago - 2 comments

#83 - DBT fails when database table is not `couchdb`

Issue - State: closed - Opened by dianabarsan 6 months ago - 1 comment

#82 - Improve BRAC model performance

Issue - State: closed - Opened by njuguna-n 7 months ago - 31 comments

#81 - Stripped out brac models

Pull Request - State: closed - Opened by njuguna-n 7 months ago - 1 comment

#80 - Implement model auditing for refactoring purposes

Issue - State: open - Opened by lorerod 8 months ago

#79 - Enhance DBT models testing

Issue - State: closed - Opened by lorerod 8 months ago - 1 comment
Labels: Type: Improvement, released

#78 - Add a way to do a full refresh when running DBT

Issue - State: closed - Opened by njuguna-n 8 months ago - 3 comments

#77 - chore: Add prerequisites to README for local testing

Pull Request - State: closed - Opened by andrablaj 8 months ago - 2 comments
Labels: released

#75 - chore: Remove dataemon mentions

Pull Request - State: closed - Opened by andrablaj 8 months ago - 1 comment
Labels: released

#74 - Merge dataemon and a part of cht-pipeline with cht-sync

Issue - State: closed - Opened by witash 9 months ago - 5 comments
Labels: Type: Improvement

#73 - feat(#72): Replace hardcoded values with env variables

Pull Request - State: closed - Opened by andrablaj 9 months ago - 8 comments
Labels: released

#72 - Replace harcoded values with environment variables in root.yml

Issue - State: closed - Opened by andrablaj 9 months ago - 1 comment
Labels: Type: Technical issue, released

#71 - Fix main branch to auto create schema and base table

Issue - State: closed - Opened by njuguna-n 9 months ago - 1 comment
Labels: Type: Bug

#70 - Generate couchdb docs to test BRAC models

Issue - State: closed - Opened by njuguna-n 10 months ago - 1 comment

#69 - Fix brac models failing after first run

Pull Request - State: closed - Opened by lorerod 10 months ago - 1 comment

#68 - Brac models chp follow up changes

Pull Request - State: closed - Opened by njuguna-n 10 months ago - 2 comments

#67 - BRAC - Models failing after first run

Issue - State: closed - Opened by njuguna-n 10 months ago - 3 comments

#66 - BRAC - CHP Follow Up - Create duplicate "CHP Follow Up" dashboard

Issue - State: closed - Opened by njuguna-n 10 months ago

#65 - BRAC - CHP Follow Up - Set up "PostgreSQL (BRAC UG) - Date Ranges" data source

Issue - State: closed - Opened by njuguna-n 10 months ago

#64 - BRAC - CHP Follow Up - Set up "PostgreSQL (BRAC UG)- Hierarchy" data source

Issue - State: closed - Opened by njuguna-n 10 months ago - 10 comments
Labels: Status: Blocked

#63 - BRAC - CHP Follow Up - Set up "PostgreSQL (BRAC UG)- branch" data source

Issue - State: closed - Opened by njuguna-n 10 months ago

#62 - BRAC - CHP Follow Up - Set up "All CHP with Branches" data source

Issue - State: closed - Opened by njuguna-n 10 months ago

#61 - Brac models anc incremental

Pull Request - State: closed - Opened by njuguna-n 10 months ago

#60 - Compare BRAC ANC model output

Issue - State: closed - Opened by njuguna-n 10 months ago - 1 comment

#59 - Convert BRAC ANC models to use incremental tables

Issue - State: closed - Opened by njuguna-n 11 months ago - 1 comment

#58 - fix and extend `npm run prod` command

Issue - State: closed - Opened by njuguna-n 12 months ago - 1 comment
Labels: Won't fix: Deprioritized

#57 - BRAC data sync benchmarking

Issue - State: closed - Opened by njogz over 1 year ago
Labels: Type: Performance

#56 - Migrate BRAC to cht-sync

Issue - State: closed - Opened by njogz over 1 year ago - 1 comment

#55 - Investigate issue of views being dropped while DBT is running

Issue - State: closed - Opened by njuguna-n about 1 year ago - 4 comments

#54 - Logstash failing on MoH UG instance

Issue - State: closed - Opened by njuguna-n about 1 year ago - 2 comments

#53 - Investigate slow queries in the MoH Ug cht-sync instance

Issue - State: closed - Opened by Phil-Mwago about 1 year ago - 3 comments