Narrator Docs

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



Updated 16 days ago


What's Next

Check out the day 1 tutorial

Create your first transformation

BigQuery


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.