BigQuery

This guide provides step-by-step instructions for connecting Google BigQuery to Unistream.

Prerequisites

You will need:

• A Google account with access to Google Cloud Console

• Access to your BigQuery datasets

• Service Account JSON key file (see Service Account for instructions)

• Unistream platform credentials

Setup Steps

1. Enable BigQuery API

1. In Google Cloud Console, go to APIs & Services → Library

2. Search for BigQuery API and click Enable

   

2. Assign Role to Service Account

1. In Google Cloud Console, go to IAM & Admin → IAM

   
2. Find your Service Account in the list and click the Manage Permissinons

   
3. Navigate to the Permissions tab and click Manage Permissions

4. Click + ADD ROLE

   
5. Search for and select BigQuery Data Admin → Click Save

   

3. Connect to Unistream

1. In Unistream, navigate to Lake

2. Click Add Source

3. Select Google BigQuery

4. Fill in the General Fields:

   • Name: Enter a name for your connection

   • Code: Enter a unique code identifier

5. Fill in the Connection Details (see Service Account):

   • Project ID: Enter your Google Cloud Project ID from your JSON key file (found under project_id)

   • Service Account Email: Enter the email from your JSON key file (found under client_email)

6. Upload your Service Account Key:

   • Click Upload File or drag and drop your JSON key file This is the file you downloaded when creating your Service Account

7. Click Test Connection

8. If the connection is successful, click Add to save your connection