Error with MIMIC III and MIMI IV with BigQuery #1858
Replies: 6 comments 4 replies
-
|
Can you give an example of a query that's giving this error? |
Beta Was this translation helpful? Give feedback.
-
|
SELECT *
FROM `physionet-data.mimiciv_hosp.patients`
WHERE subject_id < 10000100
ORDER BY subject_id
…On Tue, Feb 18, 2025 at 9:10 AM Mary M Lucas ***@***.***> wrote:
Can you give an example of a query that's giving this error?
—
Reply to this email directly, view it on GitHub
<#1858 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/APCACEWT6AWEYQJMEZ7JB7L2QNSQNAVCNFSM6AAAAABW6QYWDCVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTEMRTHE3TEMI>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
--
Sandeep S. Bains
|
Beta Was this translation helpful? Give feedback.
-
|
I just copied and pasted this query and it runs for me with no error. Just to confirm, you have signed the DUA and have access on the Physionet page for the dataset. And you also requested BigQuery access? I assume that should be the case because you can see the files in your explorer but just wanted to doublecheck because that is the only reason I can think of why it would give this permission error. |
Beta Was this translation helpful? Give feedback.
-
|
I just thought of something else: make sure that the project ID you have in BigQuery is your own project ID (https://developers.google.com/workspace/guides/create-project) and not the 'physionet-data' ID. We can't use physionet-data as the project ID because our usage needs to be billed to our own account. |
Beta Was this translation helpful? Give feedback.
-
|
Your Google account does not have permission to access the data. Make sure you request BigQuery access through PhysioNet, and that the Google account in your profile is the same as the one you are using to query the data. |
Beta Was this translation helpful? Give feedback.
-
|
Hello,
Thank you for your response.
I did request access for my gmail as my alternative email address since I
am using my gmail + bigquery together. But, I have to use my university
email for physionet as my primary email. This was also my thought for why
it may not be working given the error message I get with the query.
Whats the best way to resolve this issue?
Sandeep
…On Thu, Feb 20, 2025, 05:37 Alistair Johnson ***@***.***> wrote:
Your Google account does not have permission to access the data. Make sure
you request BigQuery access through PhysioNet, and that the Google account
in your profile is the same as the one you are using to query the data.
—
Reply to this email directly, view it on GitHub
<#1858 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/APCACESMHG32JXUHTQCRD2D2QXLDPAVCNFSM6AAAAABW6QYWDCVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTEMRWGM2TMNA>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
Beta Was this translation helpful? Give feedback.
-
|
If your University email is a Google account, then you can update your profile in PhysioNet to have the University account for Google and re-request access on the project page. There is no requirement that it is a Gmail account. |
Beta Was this translation helpful? Give feedback.
-
|
The university acct is not a gmail. Its ***@***.*** I put my gmail as
my alternate email and tried to request access for my alternate email
address too.
…On Thu, Feb 20, 2025, 06:08 Alistair Johnson ***@***.***> wrote:
If your University email is a Google account, then you can update your
profile in PhysioNet to have the University account for Google and
re-request access on the project page. There is no requirement that it is a
Gmail account.
—
Reply to this email directly, view it on GitHub
<#1858 (reply in thread)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/APCACEVTZTWKYXEQLBXRV2T2QXOULAVCNFSM6AAAAABW6QYWDCVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTEMRWGM4TENQ>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
Beta Was this translation helpful? Give feedback.
-
|
Is using my alternative gmail listed on physionet and requesting access
fine as opposed to my university email for bigquery?
…On Thu, Feb 20, 2025 at 6:15 AM Sandeep Bains ***@***.***> wrote:
The university acct is not a gmail. Its ***@***.*** I put my gmail
as my alternate email and tried to request access for my alternate email
address too.
On Thu, Feb 20, 2025, 06:08 Alistair Johnson ***@***.***>
wrote:
> If your University email is a Google account, then you can update your
> profile in PhysioNet to have the University account for Google and
> re-request access on the project page. There is no requirement that it is a
> Gmail account.
>
> —
> Reply to this email directly, view it on GitHub
> <#1858 (reply in thread)>,
> or unsubscribe
> <https://github.com/notifications/unsubscribe-auth/APCACEVTZTWKYXEQLBXRV2T2QXOULAVCNFSM6AAAAABW6QYWDCVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTEMRWGM4TENQ>
> .
> You are receiving this because you authored the thread.Message ID:
> ***@***.***>
>
--
Sandeep S. Bains
|
Beta Was this translation helpful? Give feedback.
-
|
Yes, you can use any personal gmail account. |
Beta Was this translation helpful? Give feedback.
-
I keep getting an error message: Access Denied: Table physionet-data:mimiciv_hosp.patients: User does not have permission to query table physionet-data:mimiciv_hosp.patients, or perhaps it does not exist.
The MIMIC files are all present in my explorer so I am not sure what other access to request. Has anyone else run into this issue?
Beta Was this translation helpful? Give feedback.
All reactions