Google Cloud Platform: Error When Running SQL

Google Cloud Data Analytics
,
1

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,

2

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

VishalBulbule_0-1651038084300.png
VishalBulbule_0-1651038084300.png400×235 25.9 KB

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

1 Like