Knowledge Drop

User doesn't have permission

Userlevel 1

Last tested: Jan 7, 2020

The Problem

User doesn't have 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

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


This content is subject to limited support.                



0 replies

Be the first to reply!