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

Looker Tips & Resources Technical Tips & Tricks
,
1

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-279322. actions-279322 is the value we need for our looker connection in this case:

2

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?

3

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

4

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.