User does not have bigquery.jobs.create permission in project error

If we are hitting the error “BigQuery connection is hitting this error User does not have bigquery.jobs.create permission in project `project_name`” for a connection where we have granted the user the BigQuery Data Editor and  BigQuery Job User role already then we may need to check our value for the `Project Name` parameter in the connection.

For bigQuery connections `Project Name` in the connection panel needs to be  the `Google project ID` rather than the name per our docs here.

In this example we click on the project name Actions in the BQ console which shows us the project ID is actions-279322actions-279322 is the value we need for our looker connection in this case:

d2fd14a2-f607-42ee-bbb7-7823ca1aff95.png
3fd07d8d-4d54-4514-9ccb-6dcb90843739.png
Comments
Blake1
New Member

What if some users get that error and others do not? I don’t think it’s the project name at that point. What do I need to check in BQ so specific users can view the look?  

vinhot001
Observer

Using the ProjectID instead of the Project Name does not help. Please help with any other possible suggestions.

jasonvanderweel
New Member

For us we have a stage/prod project. We had to add the SA to the other project in order for the user attribute connection to cross-over properly.

Version history
Last update:
‎05-21-2021 07:19 AM
Updated by: