Bigquery-public-date permissions issues

[Mlandow]

Hi all. Hoping someone can help me out with this. I am taking the Google Data Analytics Certificate Course and I am in Course 3 at this point.  I am following this tutorial below but when I try to create a dataset of my own, I get the message on the second screenshot.  Does anyone know how I can create a permission for myself?  Any help would be much appreciated.

[ghayas_muhammad]

1--Go to this Google Cloud link[1]

2--Go to Google Console

3--Change the permission for the project from "editor" to "owner".

4--Follow the latest instructions—but as of the time of this writing, go for the IAM role to change the permissions.
[1] https://cloud.google.com/bigquery/docs/access-control-basic-roles?hl=en&_ga=2.99188510.-12734616.162...

[fchin]

Hi, I am having the same issue as above. I am able to enable IAM role for my "
first project" but not for "bigquery-public-data". 

[fchin]

HI Mlandow, were you able to get it to work? I am not able to grant the IAM role to bigquery-public-data

[kolban]

Looking at the request you are executing, it seems to say to me that you are trying to create a new dataset in the project called bigquery-public-data and it is failing.  I fully expect that to be the case.  When we think about data in BigQuery, we have three concepts:

• The project - Which owns datasets and is billed for storage
• The dataset - A collection of tables and views which is owned by a project and hence is where billing for data contained in the dataset will be billed
• Tables and views - Tables and views that are contained within a dataset which is contained within a project and where the billing will occur

These three concepts play together.  One can define access permissions which define which identities (users and service accounts) can read/write and create/delete/update definitions.   Google owns a project called bigquery-public-data which contains datasets and tables that are publicly accessible.  One can read the data contained in this project.  Google itself pays the bill for storing this data.  Data contained within is made available (storage) without charge and it contains public data.

Getting back to the original post ... it appears that you are trying to create your OWN dataset in this project.  Google will prevent you from doing that.  If you want to create your own dataset you will need to create it in your own project.   If you are following a recipe/tutorial, look carefully at the instructions.  Could you have mis-read the project into which you are to create the dataset?  If you re-read and find that you are indeed correctly following the instructions, please post a link to such.  It is not impossible that there could be an error in those instructions that is indeed asking you to create a dataset in the public project ... but ... if that were the case, my opinion is that would be an error to be corrected in the instructions.

[brown80011]

Kolban, 

This is an issue within the tutorial when following along students such as myself and others are running into this issue. We are only mimicking what we're being shown in the tutorial and this issue is occurring with following along. Also, there isn't a straightforward answer to resolving this issue. Is this something that could be associated with Google Workspace accounts? Honestly, this is frustrating because it seems we're reaching out for help and being stonewalled like it's our fault instead of listening to us and offering real help to a real issue. This is a big problem because this issue is hindering us from completing a certification that we've paid for.

[kolban]

Do you have a link to the specific tutorial itself?   I believe (though could be wrong) that you are working a Coursera based course.  This forum is a community where folks with a similar interest (in this case Data Analytics) can converse and chit/chat.  Looking at the Coursera based web site, I found the following:

https://www.coursera.support/s/learner-help-center-troubleshoot?language=en_US

That appears to be a place where learners can post questions to Coursera for addressing.   Not having seen the Coursera content, I can't comment on the instructions or their correctness.   What I can say is that there should not be an instruction that asks for the creation of a dataset in the Google Cloud project called bigquery-public-data.   That would not in any way be related to Google Workspace accounts.   That project is owned by Google for the sole purpose of distributing public tables.  There is no possibility for arbitrary additional datasets nor tables to be placed in there during the executions of a tutorial.