sagerx
sagerx copied to clipboard
coderxio
Open drug data pipelines curated by pharmacists.
# Problem Statement We need a wholesale review of our current Airflow DAGs and dbt setup for each data source from beginning to end. # Criteria for Success Every checkbox...
# Problem Statement When trying to run DailyMed Full DAG (50,000 SPLs), I run into the error shown below. This is from the build in branch jrlegrand/dailymed # Criteria for...
# Problem Statement Right now, we have CMS Part D DAG in a "hidden_dags" folder because it was causing an error for me and at least one other person when...
# Proposal Parse the fda_ndc package field into a package equivalency table # Rationale adds digestible package information for people to use tied to NDCs
# Problem Statement We arbitrarily chose the first day of the month for the RxNorm DAG schedule, but it looks like it can be updated on days 1-6 or so...
# Proposal Something like this: ``` select distinct cls.class_type , trim(cls.class_name) as class_name , cpi.ingredient_rxcui , cpi.ingredient_name , cpi.ingredient_tty from staging.stg_fda_ndc__class cls left join staging.stg_fda_ndc__ndc ndc on cls.productid = ndc.productid...
# Problem Statement RXN_AI was previously named RXN_BOSS_AI and attached to SCDC prior to September 2021 release. RXN_AM was previously named RXN_BOSS_AM and attached to SCDC prior to September 2021...
# Problem Statement DAG runs for a while and then errors out. Doesn't do this on my local machine. Brief googling suggests it's memory related, but hard to diagnose. See...
## Explanation Changed the common transform task to handle multiple levels of transformation (staging alone or staging and intermediate). I still need to figure out the best way to handle...
# Problem Statement Need to extract a linkage from NDC -> image file name from DailyMed XML. # Criteria for Success Data mart for NDC -> image # Additional Information...