Before you start

Please make sure you have permission to configure the following:

• Create a User in BigQuery

Step - 1: Go to BigQuery

BigQuery Console

Step 2 - Grant Permissions

Search for the 'BigQuery Admin' permission

What if you don't want to grant Admin permissions?

If you’re using the predefined roles in BigQuery, you need to use the admin role since it’s the only one that can create queries and list tables.

Want to create your own role? The permissions you need to assign are:

Role: DLP API Service Agent

or

Create a custom role with the following permissions
bigquery.datasets.get
bigquery.datasets.create
bigquery.tables.list
bigquery.tables.get
bigquery.tables.create
bigquery.tables.updateData
bigquery.tables.update
bigquery.tables.getData
bigquery.tables.delete
bigquery.jobs.create
bigquery.jobs.get
bigquery.jobs.update
bigquery.jobs.list

Step3 : Download the file

select Create Key

Press Create

This will download a file to your account

Step 4 - Copy the project_id from URL

Step 5 - Add the file and project ID in Narrator.

Step 5 - Add the processing location

Go to your console: https://console.cloud.google.com/bigquery

Click an on any dataset and make sure the Data Location is the same and input that location

Step 6 - Test and Save

Press the 'Test and Save' button. You should see that the warehouse was successfully connected. If not, verify that you've granted the proper permissions and try again.

If you get stuck feel free to contact us