Roadway Docs
  • Getting started
    • Quickstart guide
  • Implement Roadway
    • Warehouse-native
      • Connect Snowflake
      • Connect BigQuery
      • Connect Redshift
    • Direct connectors
  • Data Requirements
    • Warehouse Requirements
      • Visits (Sessions)
      • Users
      • Revenue
      • CRMs
      • Ad Spend
  • Required IDs for attribution
    • Implementing the Roadway Tag
      • Add Anonymous IDs to CRM with Custom Forms
        • Segment with Custom Forms
        • Google Analytics with Custom Forms
      • Add Anonymous IDs to CRM with Hubspot Forms
        • Google Analytics with Hubspot Forms
Powered by GitBook
On this page
  1. Implement Roadway
  2. Warehouse-native

Connect BigQuery

PreviousConnect SnowflakeNextConnect Redshift

Last updated 3 months ago

Connect Roadway to BigQuery

We have set up our service account in our Google Cloud project for you to connect to. Your company specific service account email will be provided by Roadway directly.

  1. Go to the Google Cloud Console and select your project.

  2. Navigate to IAM & Admin > IAM.

  3. Click Add.

  4. In the New Members field, enter the service email provided to you by Roadway

    1. Assign the following roles:

      • BigQuery Data Viewer – for read-only access to your BigQuery data.

      • BigQuery Job User – to allow for query execution.

    2. Click Save to apply the changes.

  5. Using your own appropriately permissioned account, create a roadway dataset in your BigQuery project. For the above service email provided by Roadway, grant the following roles on this dataset:

  6. Assign the following roles:

    • BigQuery Data Editor - for read and write permissions on this dataset

    • BigQuery Job User - to allow for query execution (this may be inherited via step 4a above)

  7. Click Save to apply the changes.

‍‍

Access Management

Once access is granted, send us the project ID of the datasets you granted us permission to in Slack. Once received, we will securely connect to your BigQuery warehouse.

Data Warehouse Requirements