what is the different between concepts folder and concepts_postgres folder

MIT-LCP / mimic-code

MIMIC Code Repository: Code shared by the research community for the MIMIC family of databases

https://mimic.mit.edu

MIT License

2.51k stars 1.5k forks source link

what is the different between concepts folder and concepts_postgres folder #1430

Closed huangzhuohua closed 1 year ago

huangzhuohua commented 1 year ago

as we can see two concepts relevant folders in this path /mimic-code)/mimic-iv/ what is the different between concepts folder and _conceptspostgres folder? if i use postgresql as my database, which is my choice to make concepts ?

alistairewj commented 1 year ago

If you are using postgresql, then use the concepts_postgres folder. The concepts_postgres folder is automatically generated from the scripts in the concepts folder. They are identical in logic, just some syntax differences between BigQuery SQL (concepts) and PostgreSQL (concepts_postgres).