Integrating with BigQuery

Prerequisites

BigQuery Setup Add an external user in BigQuery

Prerequisites

To connect BigQuery to Drivetrain, you need:

• An active BigQuery account

• Sharing privileges on BigQuery

• Admin privileges in Drivetrain

BigQuery Setup

Drivetrain supports integration with BigQuery from a read-only external user account. To get started you would need to share the read-only access with [e-mail] service account.

Add an external user in BigQuery

To grant an access to external user, (someone who is not listed as an employee in the company), follow these steps:

1. Select the Dataset/ Resource which is to be shared with the user.

2. From the Sharing option on the right top of the page, route to Permissions.

3. Add [e-mail] as principal.

4. Assign role - Set as BigQuery Data Viewer.

5. Select the above role & click Save

That’s it! Share the below details with your Customer Success Manager or Data Integrations Manager so that they can get started:

1. If you have given access to complete dataset, please share Project ID/Name and Dataset Name.

2. If you have given access to specific tables in the dataset, please Project ID/Name, Dataset Name and Table Names.