'BigQuery public datasets cannot be found (`bigquery-public-data`)
In the left panel of BigQuery, the dataset bigquery-public-data is nowhere to be found.
I have no idea how it disappeared. Does anyone have a solution to integrate it back?
Solution 1:[1]
In the old (Classic) UI, you can pin the project back by following the steps in the "Adding a project" section of this document. There is a screenshot in the link.
I'm not sure how it disappeared from your Console, but there is a "Remove project from panel" option in the down arrow icon next to each pinned project.
Solution 2:[2]
I am currently enrolled in the Google Data Analytics course and just found where an instructor told us how to pin the bigquery-public-data to the explorer!
In the search bar of your explorer, type "public" and then select the broaden search in blue. This should populate the bigquery-data-public so that you are able to pin it to your explorer.
I have spent two days trying to figure this out so I hope this reaches someone in need!
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | ch_mike |
| Solution 2 | Jada |