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
- 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
- Copy the entire contents of the obtained JSON Key and paste it into the JSON Key form on TROCCO's Create Connection Settings screen.