List view
1. Need to get the pack size mart up and running. This starts with fixing the aggregate_product bug. Even after that's fixed, it won't be perfect, but it will be a starting point. Load into the Supabase database and API. 2. Get NADAC pricing (and maybe also NADAC historical pricing) loaded into the Supabase database and API. 3. Keep these and any other necessary data marts updated for the API. A major benefit of an API is that it's always up to date. Do this manually as long as it takes, but eventually automate it. This is your "production" server if you want to call it that. Just like the s3 bucket is "production" for clients. 4. Once you have NADAC + pack size updated, you could make a view in Supabase (or maybe a new mart in SageRx now that I come to think of it. This mart would return what the total NADAC pricing should be for a given NDC. A public utility issue with NADAC is that it uses a closed source (proprietary) database to calculate total price. So for anyone else to compare pricing would require them to use the same methodology to convert their total price to units. Here I will offer an attempt at using open source methodology to do that so that people have some standard to compare to. 5. Then, pharmacies could upload just a list of NDCs and what they paid for them, and we could attempt to compare what they paid to what we think the NADAC should be. They can flag errors on the site to help us identify issues with our pack size methodology. Overtime, it would get pretty accurate.
Due by November 30, 2025•1/1 issues closedAutomate all Airflow DAGs Automate mart creation - and maybe all transformations in general(?) - by just calling dbt model build commands on a weekly / monthly basis. Maybe use tags in dbt models to do this?
Overdue by 6 month(s)•Due by February 28, 2025•0/5 issues closed