Introduction

Google’s BigQuery allows you to share a dataset to Kubit securely through Service Account. Because BigQuery separates computing from storage, Kubit will cover the cost of querying and won’t impact your SLA.

Share a Dataset

  • Kubit will provide you a Kubit Service Account Email, typically in the format of <YOUR_ORG>@kubit-oauth.iam.gserviceaccount.com
  • Alternatively, you can create a Service Account and share the JSON key file with Kubit. Please make sure to add [email protected] to "Service account users role" in step 3 "Grant user access to this service account (Optional)".
  • In the BigQuery console, select a dataset from Resources, then click SHARE DATASET near the right side of the window.
15601560
  • In the Share dataset panel, in the Dataset permissions tab, enter the previously created Kubit Service Account Email to the Add members field. Then select the role BigQuery Data Viewer, click Add, then click DONE.
16001600
  • If you need to share multiple datasets from different GCP projects, you can just use the same Kubit Service Account Email when sharing every dataset.

That's it!

Create Service Account‍

Enable BigQuery API

412412
  • Search for “BigQuery API
457457
  • Select it and click ENABLE
372372

Create Account

566566
  • Click “CREATE CREDENTIALS” and choose “Service account
565565
  • Enter “Kubit” as the name for the service account. Then click CREATE.
  • Note: "Service account email" shown on the screen (e.g. kubit-###@<GCP-PROJECT_NAME>.iam.gserviceaccount.com) is "Kubit Service Account Email"
573573 534534

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

447447
  • Select JSON in the popup window. Click CREATE.
366366
  • A JSON private key file will be downloaded to your computer.

📘

Important

Please send this file to Kubit securely!

  • Click CLOSE.