How to check Google BigQuery permission

Check if you gave the right permission

  1. First of all, move to the Google Cloud BigQuery console.
  2. Log in with owner level account (recommended) so that you can see all the permissions granted to the account. 
  3. Click the 'more' button, which is the red box on the screenshot. Then click the "Open" button to view the dataset information. 

4. Click the "Sharing" button and then "Permissions" button to view permission details.
     

5. Check if the target account has permission, which means it should show up on this list.
     If not, please give the right permission to it by adding a principal like the one below. 



6. Until above, it was a process for granting access to the dataset.
    Please do the same for the table by clicking the button on the red box below.