RADar-AZDelta / Rabbit-in-a-Blender

An ETL pipeline to transform your EMP data to OMOP.
https://radar-azdelta.github.io/Rabbit-in-a-Blender/
GNU General Public License v3.0
11 stars 3 forks source link

Check that the concept_ids in the Usagi CSV's are present in the CONCEPT table (BigQuery) #44

Closed pjlammertyn closed 5 months ago

pjlammertyn commented 5 months ago

Because BigQuery doesn't has the concept of foreign keys. We will need to add an check that the concept_ids in the Usagi CSV's are present in the concept table.

ex: below an example of concept id's that were not not present
image