Understanding SQL, OMOP, & BigQuery | Office Hours 1.26.24

In this video, Aymone Kouame, a data scientist on our team, provides an overview of concept relationships and mapping in Observational Medical Outcomes Partnership (OMOP) Common Data Model (CDM), example queries for All of Us electronic health record (EHR) domains, and how to use BigQuery sessions efficiently.

Note: This Office Hours revisits themes presented in the previous “Introduction to Electronic Health Record (EHR) Data” Office Hours session on January 12, 2024.

During this Office Hours, you'll learn:

• About OMOP and its structure
• About concept hierarchy and concept_relationship and concept_ancestor tables
• How to use BigQuery to query info into Jupyter Notebook