Notes on referencing BigQuery tables generated from SpreadSheets

summary

BigQuery tables generated from Google Spreadsheets must be referenced with connection information using a service account with appropriate permissions.

BigQuery tables generated from Google Spreadsheets cannot be referenced with OAuth-authenticated connection information.
It must be referenced by connection information using a service account with appropriate authorization.

1. Create a BigQuery service account.
   *Please refer here for necessary authorization information.

2. Add the email address of the service account to the target SpreadSheet's share settings.

3. Go to the BigQuery connection information creation screen from TROCCO and click here to create a service account (JSON key ).

4. Follow the prompts to enter the required information and click Save.

If you have any other questions or concerns regarding the use of this service, please contact a TROCCOCS representative.