Google Cloud Platform: Error When Running SQL

[chaosctrl7]

Hello,

I created a "Sandbox" account as instructed by a presenter from Google (Data Analytics program offered by Google). As a result, I now have a Google Cloud Platform account. My current assignment asks me to navigate to "BigQuery" where I am able to add data and write SQL.

For some reason, I started off with a default project with a random title (left side under explorer). The issue here is that:

When I click "view public data set", it does not pin to the left or under any other category.

The second problem is that I do not have a project titled "big query-public-data" unless I use a different link (https://console.cloud.google.com/bigquery?project=bigquery-public-data&page=project). However, even if I use that correct link, I still do not have the "permissions" to write SQL, share, create a table, etc.

I hope you can help!

Regards,

[VishalBulbule · Accepted solution]

You will not see bigquery-public-data project in your project list also could not see public dataset by default.

Try below - 

Copy and paste the below URL in your browser and pin the public dataset, then you will be able to see even you returned to your project as well.

https://console.cloud.google.com/bigquery?project=bigquery-public-data&page=project

Once you able to see public dataset , create table in your project using public dataset table then you able to use create/update or other DML statements.

Let me know if it resolve your issue or still have any query