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.41k stars 1.5k forks source link

mimiciii_derived.pivoted_uo was not found when Calculating Sofa concept #1698

Open bettyJin opened 5 months ago

bettyJin commented 5 months ago

Prerequisites

Description

I am trying to write an SQL for a modified version of the SOFA score based on mimic-iii/concepts/pivot/pivoted_sofa.sql. However, when I try to run pivoted_sofa.sql (I haven't made any change yet), it reports "Not found: Table physionet-data:mimiciii_derived.pivoted_uo was not found in location US " Error

Since in README for concepts folder, it mentions

You do not need to generate the concepts if you are using BigQuery! They have already been generated for you. If you have access to MIMIC-III on BigQuery, look under physionet-data.mimic_derived.

So I checked the file under the direction of physionet-data.mimic_derived in my BigQuery, to see if I could find the result of mimic-iii/concepts/pivot/pivoted_uo.sql. As folder columns show at the left of the image, pivoted_uo is missing. I can see other files (i.e. pivoted_gcs) and am able to access them through SQL.

Any idea why only mimiciii_derived.pivoted_uo is missing?

Screen Shot 2024-01-26 at 3 05 32 PM