Skip to content

aline notebook throws error #1706

Description

@suriyan3

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions