SQL, OMOP, & BigQuery - Jan. 26th, 2024

  • Updated

Office Hours: 1/26/2024

Topic: Overview of OMOP Common Data Model and All of Us data structure with live demonstration in some data wrangling tips in the Jupyter notebook. 

Description: Aymone Kouame, a Data Scientist on our Research Support team, provides an overview of concept relationships and mapping in OMOP, example queries for All of Us EHR domains, and how to use BigQuery sessions efficiently. In this presentation, we review topics such as concept hierarchy, the concept_relationship and concept_ancestor tables, and a live demonstration of using BigQuery to query information into the Jupyter Notebook. This Office Hours revisits themes presented in the previous “Introduction to All of Us EHR Data” - Jan. 12th, 2024 Office Hours session.

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request



Article is closed for comments.