--- title: "Connection Configuration for Google BigQuery" slug: "connection-configuration-bigquery" updated: 2024-08-15T09:33:24Z published: 2024-08-15T09:33:24Z canonical: "documents.trocco.io/connection-configuration-bigquery" --- > ## Documentation Index > Fetch the complete documentation index at: https://documents.trocco.io/llms.txt > Use this file to discover all available pages before exploring further. # Connection Configuration for Google BigQuery ## 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](/docs/connection-configuration-google-cloud-json-key) 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.