BigQuery

Connect Kubit directly to BigQuery so it queries your data in place. You enable the API, create a read only service account for Kubit, and share the credentials. Nothing is copied out of your project.

Steps

1. Enable the BigQuery API

If the BigQuery API is already enabled, skip this step.

1. Go to Google Cloud APIs and Services and click Enable APIs and Services.

   

2. Search for BigQuery API.

   

3. Select it and click Enable.

   

2. Create a service account

1. Open the Credentials page in the Google Cloud API Manager, selecting your target project if needed.

   

2. Click Create Credentials and choose Service account.

   

3. Name the account Kubit and click Create. The Service account email shown is your Kubit Service Account Email.

   

4. Assign these BigQuery roles to the Kubit service account:

   • BigQuery User

   • BigQuery Job User

   • BigQuery Data Viewer

5. Select the new service account, open Keys, click Add Key, and create a new key.

   

6. Choose JSON and click Create. A JSON private key downloads to your computer. Store it in a secure, private location.

   

3. Share connection details

Share the following with the Kubit team using a secure channel such as a password manager:

1. The JSON private key you generated.

2. Your dataset id.

3. Your dataset region and zone.

Next steps

• Understand the model: Warehouse Native

• Allow Kubit through your firewall: IP Whitelist