sagerx
sagerx copied to clipboard
coderxio
Open drug data pipelines curated by pharmacists.
# Problem Statement - [ ] Set up a Google Cloud Storage (GCS) bucket. - [ ] Likely need to configure BigQuery access to GCS bucket - and document how...
Resolves #270 ## Explanation Changes rxnorm staging and intermediate queries to using dbt's jinja table references. Most important is that it sets intermediate models to materialize as tables (vs views)....
## Explanation Sets intermediate models to materialize as tables (vs views). ## Rationale dbt mart models are made up of complex logic that should be captured in the intermediate models....
## Explanation User made changes [here](https://github.com/coderxio/sagerx/compare/main...hankerenterprises:sagerx:main) improve the following: - improve logging for zip errors for dailymed rx full DAG - nadac dag focuses on collecting only nadac links -...
# Problem Statement We already have a view that uses DailyMed SPL data via RxNorm data files to go from NDC9 -> inactive ingredients (excipients): `int_mthspl_products_to_inactive_ingredients`. It is created via...
# Problem Statement We currently export mart flatfiles to AWS s3 buckets thanks to the diligent work of our interns Miles and Komal. With the move to BigQuery, it makes...
# Problem Statement We no longer need pgAdmin since we will be using BigQuery. Airflow probably will still use Postgres locally - it automatically spins up a Postgres container or...
# Problem Statement Moving from PostgreSQL to BigQuery means we will definitely find SQL that throws errors d/t the different systems. We need to identify these areas and modify the...
Depends on #262 and to a lesser extent #266 # Problem Statement Without manual analysis, it's hard to know what changed week to week in our data marts. # Criteria...