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:

