Steps

1. Enable BigQuery API

📘

If BigQuery API is already enabled, you can skip this step.

1. Please go to Google Cloud API & Services - Dashboard. Click “+ ENABLE APIS AND SERVICES”

   

2. Search for “BigQuery API”

   

3. Select it and click ENABLE

   

2. Create Service Account

1. Open the Credentials page in Google Cloud Platform API Manager (if needed, select your target project from the dropdown list on the top).‍

   

2. Click CREATE CREDENTIALS and choose Service account

   

3. Enter “Kubit” as the name for the service account. Then click CREATE.

4. Note: Service account email shown on the screen is the "Kubit Service Account Email"

   

5. Assign the following BigQuery roles to the Kubit service account:

• BigQuery User
• BigQuery Job User
• BigQuery Data Viewer

6. Select the newly created Service account. Click Keys - ADD KEY - Create a new key.

   

7. Select JSON in the popup window. Click CREATE.

   

8. A JSON private key file will be downloaded to your computer. Please store the key in a secure and private location.

3. Share Connection Details

📘

Important

Please, share the following information with the Kubit team:

1. The JSON private key you've generated following this guide. Use a secure media such as a password manager.
2. Your dataset id.
3. Your dataset region and zone.