Query Builder Nor Working?

[clivecollins1971]

Is the Query Builder working, can't seem to get any records returned with even the simplest query of a dictionary table?

[tompollard]

@clivecollins1971 Query Builder has largely been superseded by our work to integrate with cloud platforms (e.g. Google BigQuery). We don't have capacity to continue to support Query Builder, so are likely to retire it soon.

If Query Builder is not currently working, I would suggest instead using BigQuery. If you:

• navigate to the console at: https://console.cloud.google.com/bigquery,
• click +Add Data, Pin a project > Enter project name
• type physionet-data

You should see demo versions of the MIMIC and eICU datasets.

You can access full versions of the datasets by clicking the Request access using Google BigQuery button in the files section of the relevant project (e.g. for MIMIC-III, see the Files section at: https://physionet.org/content/mimiciii/1.4/).

[clivecollins1971]

Hi Tom, thanks for coming back so quickly. I requested Google BigQuery access, and followed the link in the email received....I see I'm getting an Access Denied if I try to query...just wondering if i need to enter physionet credentials somewhere?

[clivecollins1971]

Apologies ...it's working now...thanks again!

[tompollard]

Thanks @clivecollins1971, glad to hear it worked! I had started writing a reply before you posted the update, so have left it below in case it is helpful to someone else:

I would suggest starting by querying one of the demo datasets (e.g. eicu_crd_demo or mimiciii_demo). This should work immediately, with no further steps.

My guess is that to fix the error you need to either (1) ensure you have requested access to the project on PhysioNet (in this case, https://physionet.org/content/mimiciii/1.4/). Each dataset must be requested independently (2) Try refreshing or restarting your browser...I think sometimes permissions are cached).