coderxio / sagerx

Open drug data pipelines curated by pharmacists.
https://coderx.io/sagerx
Other
41 stars 11 forks source link

Add new marts - excipients, products, and NDC sources #291

Closed jrlegrand closed 1 month ago

jrlegrand commented 1 month ago

Explanation

Added all_ndcs_to_sources as a mart and limited it to only NDCs in the existing NDC description mart so the row counts match. Added a product to inactive ingredient mart which just pulls from the existing mthspl intermediate table. Added the product marts I've been working on per request from customer.

Rationale

To make it easier to use as marts when ready.

Tests

Ran build_marts and export_marts and checked AWS s3 bucket.