Connection Configuration for Google BigQuery
    • PDF

    Connection Configuration for Google BigQuery

    • PDF

    Article summary

    summary

    This is a help page for setting up Connection Configuration for Google BigQuery.

    There are two ways to set up Google BigQuery Connection Configuration in TROCCO: using a Google account or using a service account.
    This page describes the procedure for using a service account.

    Set JSON Key

    1. Refer to Obtaining a Google Cloud JSON Key to obtain a JSON Key. Service accounts should be assigned the following roles
    • When used as a Data Source
      • BigQuery > BigQuery Data Viewer
      • BigQuery > BigQuery Data Editor
    • For use as a Data Destination or Data Mart
      • BigQuery > BigQuery Data Viewer
      • BigQuery > BigQuery Data Editor
      • BigQuery > BigQuery Data Owner
      • BigQuery > BigQuery Job Users
    1. Copy the entire contents of the obtained JSON Key and paste it into the JSON Key form on TROCCO's Create Connection Settings screen.

    Was this article helpful?