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.



    Still having issues?
    Send us a ticket and we will get back to you.
    Submit a ticket

      • Related Articles

      • How to Export to BigQuery

        Once you have a report ready in Data Explorer, you are able to export it to BigQuery. This export option is included in the Enterprise plan. Follow the instructions in this article to get started. Grant Required Roles and Permissions A successful ...

      • Google Search Console Data Connector User Guide

        The following article is a guide to automating reports with your Google Search Console connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Google Search Console ...

      • Troubleshooting BigQuery

        When troubleshooting BigQuery, you may need to view your BigQuery export logs. This article will show you how to check the logs and see details about any errors. Viewing Export Logs Your BigQuery export logs show a timestamped record of your exports ...

      • Error: Missing BigQuery Scopes

        This article will address the following error: Missing BigQuery Scopes Cause You may receive this error when connecting to a BigQuery account. It is a result of insufficient permissions granted to Power My Analytics. Solution Step 1: Disconnect ...

      • BigQuery Export Limitations

        Your data exports to BigQuery may encounter errors in certain situations such as large export sizes. This article will show you how to identify and correct errors with your BigQuery exports. Export Limitations If you are using connectors other than ...