How to Add a User to BigQuery

How to Add a User to BigQuery

To add a user to Google BigQuery, their account must be granted the appropriate permissions in Google Cloud Platform (GCP).

To grant an account access to your BigQuery instance, follow these instructions:

1. Log in to Google Cloud Console at https://console.cloud.google.com/,

2. Select your project at the top of the page next to the Google Cloud Platform logo. Make sure you're working in the correct GCP project.



3. Open the navigation menu in the top left corner. Go to IAM & Admin > IAM.





4. Go to the Permissions tab. Add a member by scrolling to View by Principals and clicking on + Grant Access.



5. Enter the new user's email address and select a role for them. These can include:
  1. BigQuery Data Viewer: Can view datasets and tables but cannot run queries.
  2. BigQuery Data Editor: Can view and edit datasets and tables, and can run queries.
  3. BigQuery User: Can run jobs including queries, but does not have permission to view the data.
  4. BigQuery Admin: Full control over BigQuery resources.




6. After choosing a role, click Save.


    • Related Articles

    • How to Export to BigQuery

      Once you have a report ready in Data Builder, you are able to export it to BigQuery. This export option is available on the Custom plan if your negotiated agreement includes data exports. Follow the instructions in this article to get started. Grant ...

    • YouTube Analytics Data Connector User Guide

      YouTube Analytics provides valuable insights into your channel's performance, audience engagement, and content effectiveness. This guide will walk you through the process of connecting YouTube Analytics to Power My Analytics, creating reports, and ...

    • Troubleshooting BigQuery Export Errors: Setup, Schema, and Code 500

      If your BigQuery export is failing (or you are not sure whether you set it up correctly), this guide walks you through the prerequisites, explains how Power My Analytics creates your tables and schema for you, and shows you how to resolve the most ...

    • Power My Analytics' Sovereign SQL Warehouse Solution

      Power My Analytics offers a Sovereign SQL Warehouse solution with the Custom plan. This article will help you learn about its uses and how to get started. The Sovereign SQL Warehouse gives you complete ownership of your data by storing it in your own ...

    • Error: Missing BigQuery Scopes

      When setting up or running BigQuery exports in Power My Analytics, you may see an error message stating “Missing BigQuery Scopes.” This means the Google account you use as your BigQuery destination is missing the permissions Power My Analytics needs ...