"mimic_derived.urine_output" does not exist

[palakaggi]

Prerequisites

• [x] Put an X between the brackets on this line if you have done all of the following:
  • Checked the online documentation: https://mimic.mit.edu/
  • Checked that your issue isn't already addressed: https://github.com/MIT-LCP/mimic-code/issues?utf8=%E2%9C%93&q=

Description

Description of the issue, including:

• what you have tried
• references to similar issues
• queries demonstrating your question (if applicable)

[palakaggi]

I am unable to load any mimic_derived schema tables. The steps I followed are https://github.com/MIT-LCP/mimic-code/tree/main/mimic-iv/buildmimic/postgres I executed create.sql, load.sql, and then even the convert_bigquery_to_postgres.sh to create the concepts. I get the following error on running postgres_make_concepts.sql: "mimic_derived.urine_output" does not exist

[cheneeheng]

Hi there,

it is possible that the "mimic_derived" schema hasn't been created. (See issue #1144). The issue is resolved and I was able to create the db without any error.

Thanks!