Code & Languages

Users may develop against Emory's OMOP-CDM with any tool that can access our data lake(s). The following are common languages used by the OHDSI community and locally at Emory.

• R & RStudio

  ---

  R is the preferred language of OHDSI developers, with extensive ready-made tooling for observational research. RStudio provides an integrated development environment for data analysis and visualization.

  HADES packages Emory's R repositories

  R training resources

• SQL

  ---

  Direct queries against Emory's OMOP data lake on Redshift. Use DBeaver, DataGrip, or any SQL client.

  Emory query library OHDSI query library

  SQL tips for OMOP General SQL reference (W3Schools)

• Python

  ---

  Increasingly used in the OHDSI community for data analysis, machine learning, and ETL pipelines. Connect using redshift_connector or any Redshift-compatible driver.

  Database connection guide