Google BigQuery connection information

summary

This is a help page for setting up Google BigQuery connection information.

There are two ways to set up Google BigQuery connection information 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 J SON Key to obtain a JSON Key. Service accounts should be assigned the following roles

• When used as a forwarding source
  • BigQuery > BigQuery Data Viewer
  • BigQuery > BigQuery Data Editor
• For use as a transfer destination or data mart
  • BigQuery > BigQuery Data Viewer
  • BigQuery > BigQuery Data Editor
  • BigQuery > BigQuery Data Owner
  • BigQuery > BigQuery Job Users

2. Copy the entire contents of the obtained JSON Key and paste it into the JSON Key form on TROCCO's connection setting creation screen.