Joseph LeGrand
Joseph LeGrand
@Mike2023 - I'm the team lead for the CodeRx MDT project. Does your database have any medication identifiers? NDC? RXCUI? Anything like that? Or is it just a bunch of...
I think the (likely disappointing to you) answer is this: We (CodeRx) did this for one MedicationOrder state (the maintenance inhaler one - not even the rescue inhaler one) within...
Man you did tons of work here. Great job. Fundamental question themes: 1. Should we title ctes specifically to what they represent even if we are just pulling in rxnconso...
I'd like to start moving toward styling our SQL like the dbt styleguide. https://docs.getdbt.com/best-practices/how-we-style/2-how-we-style-our-sql
dbt BigQuery setup: https://docs.getdbt.com/docs/core/connect-data-platform/bigquery-setup
Our strategy changed so this specific workflow is not needed.
Here's a new one... Trying to download a file via this link https://precision.fda.gov/uniisearch/archive/latest/UNII_Data.zip ... gives you the error below in an Airflow DAG. ``` requests.exceptions.HTTPError: 502 Server Error: Bad Gateway...
Tried with the direct AWS URL and got a similar error: ``` [2024-04-26, 14:45:51 UTC] {standard_task_runner.py:105} ERROR - Failed to execute job 77 for task extract (502 Server Error: Bad...
Is this a CORS error? 
Emailed FDA to ask for help.