Knowledge Drop
Last tested: Jan 7, 2020
The Problem
User doesn't have bigquery.jobs.get permission for writing to the bigquery scratch schema.
You can check if it is permission based by having them add the Admin role in big query. If this fixes their issue then try the following solution:
A Solution
In the doc for Google BigQuery it give instructions for adding for the BQ user the roles:
- BigQuery > BigQuery Job User
- BigQuery > BigQuery Data Editor
It mentions that custom roles aren't supported but if you are getting the error above try have them create a custom role to add to this user with permission bigquery.jobs.get
Another issue it could be if they have access to some PDT's but not others is that non-admin BQ users can only run jobs.get on jobs that they created themselves
LinkedIn
Twitter