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


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
project_id
from URL

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


Step 5 - Add the processing location
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
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
Updated 2 months ago