search

OHDSI / ETL-CMS

Workproducts to ETL CMS datasets into OMOP Common Data Model
Apache License 2.0
94 stars 52 forks source link

Refactor SQL scripts and provide instructions on how to set up Postgres db #58

Closed topspinj closed 2 years ago

topspinj commented 5 years ago

I'm relatively new to ETL-CMS code and thought it would be helpful to refactor SQL scripts to make them more user-friendly for future users (no need to change paths inside SQL script). Also thought it would be useful to have step-by-step instructions on how to set up the Postgres database from scratch.

The PR contains two updates: 1) Remove local path from SQL scripts. You can pass in your own path using data_dir. 2) Provide step-by-step instructions on how to set up the Postgres database locally.

Next step would be to provide instructions on how to set up Postgres database in the cloud.

ChristopheLambert commented 2 years ago

Thank you Jill for these contributions!