Drivetrain Integration Guide
  • INTEGRATION GUIDE
    • Integrate with Drivetrain
      • Accounting & ERP
        • Integrating with Certinia
        • Integrating with NetSuite
        • Integrating with QuickBooks
        • Integrating with Rillet
        • Integrating with Sage Intacct
        • Integrating with Tally
        • Integrating with Xero
        • Integrating with Zoho Books
      • BI
        • Integrating with Looker
        • Integrating with Tableau
      • Billing & Invoicing
        • Integrating with Chargebee
        • Integrating with Invoiced
        • Integrating with Maxio Chargify
        • Integrating with Maxio SaaSOptics
        • Integrating with Recurly
        • Integrating with Stripe
        • Integrating with Subscript
      • CRM
        • Integrating with Active Campaign
        • Integrating with HubSpot
        • Integrating with LeadSquared
        • Integrating with Outreach
        • Integrating with Pipedrive
        • Integrating with Salesforce
      • Customer Success
        • Integrating with ChurnZero
        • Integrating with Freshdesk
        • Integrating with Planhat
        • Integrating with Zendesk
      • Databases and Warehouses
        • Integrating with Azure SQL Server
        • Integrating with BigQuery
        • Integrating with Databricks
        • Integrating with Redshift
        • Integrating with S3
        • Integrating with Snowflake
        • Integrating with Snowflake (Small Datasets)
        • Integrating with Google Cloud Storage
        • Integrating with Postgres
      • HRIS & ATS
        • Integrating with ADP
        • Integrating with ADP Workforce Now (SFTP)
        • Integrating with Ashby
        • Integrating with BambooHR
        • Integrating with Darwinbox
        • Integrating with Deel
        • Integrating with Greenhouse
        • Integrating with Gusto
        • Integrating with HiBob
        • Integrating with Justworks
        • Integrating with Lever
        • Integrating with Namely
        • Integrating with Paylocity
        • Integrating with Personio
        • Integrating with Sapling
        • Integrating with UKG Pro
        • Integrating with Zenefits
      • Spreadsheets
        • Integrating with Airtable
        • Integrating with Google Drive
        • Integrating with Google Sheets
        • Integrating with Microsoft OneDrive
      • Others
        • Integrating with Brex
        • Integrating with Clari
        • Integrating with NetSuite (Role Based Access)
        • Integrating with Shopify
        • Integrating with Twilio
        • Integrating with Officevibe
        • Integrating with SFTP
        • Integrating with Drivetrain's SFTP
        • Setting up SSO
Powered by GitBook
On this page
  • Prerequisites
  • BigQuery Setup
  • Add an external user in BigQuery

Was this helpful?

  1. INTEGRATION GUIDE
  2. Integrate with Drivetrain
  3. Databases and Warehouses

Integrating with BigQuery

PreviousIntegrating with Azure SQL ServerNextIntegrating with Databricks

Last updated 2 months ago

Was this helpful?

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 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 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.

drivetrain@integrations-417606.iam.gserviceaccount.com
drivetrain@integrations-417606.iam.gserviceaccount.com
Prerequisites
BigQuery Setup
Add an external user in BigQuery
Page cover image