Prerequisites
Description
I am running my postgres db in docker. I have loaded the data which i have downloaded from https://physionet.org/content/mimiciii-demo/1.4/.
When I am trying to run this python notebook D:\mimic-code\mimic-iii\notebooks\aline especially this query
queries = [
'sepsis/angus.sql',
'durations/weight-durations.sql',
'demographics/heightweight.sql',
'aline_vaso_flag.sql'
]
for query_file in queries:
# load in the text of the query
f = os.path.join(concepts_path, query_file)
with open(f) as fp:
query = ''.join(fp.readlines())
query = query.replace('`', '"')
# Execute the query
print('Generating materialized view using {} ...'.format(f),end=' ')
execute_query_safely(query_schema + query, con)
print('done.')
It throws below error
relation "physionet-data.mimiciii_clinical.diagnoses_icd" does not exist
LINE 32: from "physionet-data.mimiciii_clinical.diagnoses_icd"
when i checked in mimic database I have this table diagnoses_icd. How to fix this issue.
Prerequisites
Description
I am running my postgres db in docker. I have loaded the data which i have downloaded from https://physionet.org/content/mimiciii-demo/1.4/.
When I am trying to run this python notebook D:\mimic-code\mimic-iii\notebooks\aline especially this query
queries = [
'sepsis/angus.sql',
'durations/weight-durations.sql',
'demographics/heightweight.sql',
'aline_vaso_flag.sql'
]
for query_file in queries:
# load in the text of the query
f = os.path.join(concepts_path, query_file)
with open(f) as fp:
query = ''.join(fp.readlines())
query = query.replace('`', '"')
LINE 32: from "physionet-data.mimiciii_clinical.diagnoses_icd"
when i checked in mimic database I have this table diagnoses_icd. How to fix this issue.