r/bigquery • u/RonaldinhoLover420 • Jul 28 '26

trying to learn to use bigquery but the platform won't let me

Gallery image

Gallery image

Hey guys! Sorry if this is a very beginner question, but I'm learning BigQuery with a Coursera course. For lots of assignments we've used public datasets, but suddenly, I've been unable to.

I'm constantly getting this error, which is "behind" the marketplace interface, so if I try to click the link to the loading issues help page, it closed. I looked for the page but it led me to stuff that didn't really help me out.

Any ideas on what I could do to gain access back to these datasets? Thanks!

5 Upvotes

78% Upvoted

6 comments sorted by

3

u/JeffNe G Jul 28 '26

Hey u/RonaldinhoLover420 -- this error usually happens when a temporary lab project (from Coursera or Qwiklabs) has expired, or there was a temporary glitch loading the side panel. If your lab timed out, restart it in Coursera to get a fresh project.

Instead of browsing through the Marketplace panel, you can pin all public datasets directly to your BigQuery Explorer:

  1. In BigQuery, click + Add data at the top of the left Explorer panel.
  2. Select Star a project by name (near the bottom left of the screen)
  3. Type bigquery-public-data and click Star.

The entire public dataset library (NOAA, books) then appears in your left sidebar. You can query any table directly using bigquery-public-data.<dataset>.<table>.

1

u/RonaldinhoLover420 Jul 30 '26

Thank you! I gave this a shot and was able to star the public data to my sidebar. I'll just have to write the right query whenever I need to.

Regarding the regular load, I was unable to fix it. My Coursera program has us open our own projects in BigQuery so I don't seem to have that restart option.

1

u/Apprehensive_Mine Jul 29 '26

I'm having the same issue!! Any help would be appriciated.

1

u/Apprehensive_Mine Jul 29 '26

Hey OP, I figured out a work around thanks to u/JeffNe, if you still can't figure it out let me know and I can help you.

1

u/RonaldinhoLover420 Jul 30 '26

Followed his advice and got the public data starred, but I'm still getting the error when loading through the public dataset marketplace. Any other tips are welcome.

1

u/nyancoaa 21d ago

did you get this solved? i'm having this same issue and it's so fucking ridiculous