BigQuery Console - "Failed to load" when opening Public Datasets via Marketplace (add-data(cameo:product))

Google Cloud Database
1

I’m experiencing an issue when trying to open BigQuery Public Datasets from the Google Cloud Console.

The problem does not appear to be related to permissions or IAM because I can successfully query the datasets using the BigQuery CLI (bq).

The error only occurs when the Console tries to open the dataset using the internal add-data(cameo:product) route.

Environment

  • Google Cloud Project: (PII Removed by Staff)
  • BigQuery API: Enabled
  • Account: Google Workspace / Gmail account
  • Browser: Google Chrome (latest version)
  • Operating System: Windows 11
  • Region: Brazil

URLs

The following URLs work correctly:

Documentation



https://docs.cloud.google.com/bigquery/public-data

Marketplace



https://console.cloud.google.com/marketplace/browse?filter=solution-type:dataset

Dataset page



https://console.cloud.google.com/bigquery?p=bigquery-public-data&d=un_sdg&page=dataset&project=(PII Removed by Staff)

However, when the Console redirects to:



https://console.cloud.google.com/bigquery/add-data(cameo:product/...)

the page fails to load.

Error

The Console displays:

Failed to load.

An error occurred while loading:

`/bigquery/add-data(cameo:product/bigquery-public-data/google-books-ngrams-2020)?project=(PII Removed by Staff)

The same behavior happens with multiple public datasets, not only one specific dataset.

What I already verified

image
image2214×974 284 KB

image
image1543×288 51.1 KB

BigQuery API is enabled.
*
Account authentication is correct.
*
Project is correctly selected.

  • bq CLI works normally.
  • I can query public datasets successfully.

Example:



SELECT COUNT(*)
FROM `bigquery-public-data.un_sdg.indicators`

Using the CLI:



bq query --use_legacy_sql=false \
'SELECT COUNT(*) FROM `bigquery-public-data.un_sdg.indicators`'

returns:



1050781

Therefore, BigQuery itself is working.

Troubleshooting already attempted

  • Incognito mode
  • Browser cache cleared
  • Different browsers
  • Different public datasets
  • Verified IAM permissions
  • Verified enabled APIs

The issue persists only when opening datasets through the add-data(cameo:product) route.

Question

Has anyone experienced this recently?

Is this a known issue with the current Google Cloud Console UI, or is there any workaround besides querying the datasets directly?

2

Yep. Having the same problem. I am trying to complete the Google Data Analytics Professional Certificate and cannot add any of these datasets the course is asking me to add. So frustrating.

3

Not cool, considering it is $50/mo to access the course!

4

Horrible, having the same issue

5

I had the same issue. The solution below worked to at least grant me access.

Directly Pin the Public Dataset Project
The most reliable way to bypass UI glitches (like the common add-data(cameo:product) Marketplace error) is to manually force the project into your Explorer sidebar. [1]

  1. Go to the Google Cloud BigQuery Console.
  2. Look at the Explorer panel on the left side of the screen.
  3. Click the + Add (or + Add Data) button at the top of the panel.
  4. Select Pin a project (or Star a project).
  5. Type bigquery-public-data exactly as written and hit enter.
  6. The entire repository will now permanently appear in your sidebar for easy browsing.

It doesn’t directly add the data, but gives access to all datasets in the public data.

6

Since the bq CLI can query the public datasets successfully, this looks much more like a Console/UI issue than a BigQuery or IAM problem.

The fact that multiple public datasets fail specifically when the Console redirects to the add-data(cameo:product) route is particularly telling. You’ve also already ruled out the usual browser, authentication, API, and permissions issues.

Has anyone else seen this behavior recently with the Cloud Console? If so, is there a known workaround for opening the dataset details through the Console while this route is failing?

7

I have the same Problem