BigQuery

Before you start

Please make sure you have permission to configure the following:

• Create a User in BigQuery

Step - 1: Go to "Create service account" in the BigQuery console

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?

https://docs.narrator.ai/page/how-to-setup-non-admin-permissions-in-bigquery

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