sagerx
sagerx copied to clipboard
coderxio
Open drug data pipelines curated by pharmacists.
See Notion notes for some more info: https://www.notion.so/coderxio/2024-06-25-Intern-Sync-99917acf5ee2422ab2c9896e5fbf36ca?pvs=4 Steps: - [ ] Create access for Superset - [ ] Define max data quotas - [ ] Etc
# Problem Statement The rxnorm DAG has to be turned "on" for build_marts to run it. Turning rxnorm "on" automatically runs it. I normally do this workflow: 1. Turn rxnorm...
Replace FDA UNII get_file_name function with standard get_files_in_data_folder + filter You can use the get_files_in_data_folder function already there to pull all of the downloaded data files. It returns a list...
# Problem Statement See error log below. As you can see in the screenshot, it only affects some tasks. I ran the RxNorm DAG and then tried doing gcp_push. [dag_id=dbt_gcp_run_id=manual__2024-07-02T15_37_21.389188+00_00_task_id=bq_load_sagerx_dev.int_mthspl_products_to_active_ingredients_attempt=2.log](https://github.com/user-attachments/files/16075013/dag_id.dbt_gcp_run_id.manual__2024-07-02T15_37_21.389188%2B00_00_task_id.bq_load_sagerx_dev.int_mthspl_products_to_active_ingredients_attempt.2.log)...
# Problem Statement 30-someting out of 17k+ excipients / inactive ingredients / substances in our data mart have UNII codes but did not map to most recent UNII data. Will...
# Proposal Do this: https://docs.getdbt.com/reference/resource-configs/persist_docs # Rationale Make it easy to work with descriptions in BigQuery without having to refer to dbt docs.
Goal: explore the costs / features / customization potential of Superset. **Feature wishlist:** - Embed dashboard in website - Share dashboard publicly - Share dashboard with limited access (specific users?...
## Explanation Built dag that polls ASHP for detailed shortage information and loads into SageRx database. ## Rationale New feature implemented after discussion with @jrlegrand ## Tests 1. What testing...
# Problem Statement ## NDC with spaces instead of dashes NDC 55292 140 01 a0aad470-3f38-af97-e053-2995a90a383a ## NDC jammed up against a pill count NDC 81520-100-3030 TabletsRx only 0cc52ac5-77ec-4d66-a770-762a1a960914 Maybe RegEx...
# Problem Statement Need to account for this, but not sure how widespread it is. Also, could try to associate the closest referencedObject with the NDC in the text for...