BigQuery

Prerequisites

5X uses static IPs to connect to your warehouse, please make sure your firewall is configured to allow the connection from these IP addresses.

3.217.202.216
3.211.173.46
174.129.146.62

Setup

For 5X to access your Google BigQuery, you need to create a Service Account key.

To create a Service Account Key, you will need at least Service Account Key Admin IAM role on the project (roles/iam.serviceAccountKeyAdmin). For more information about granting roles, learn here.

Once you share a Service account key with us, we get the privilege to do access the following APIs on your behalf.

BigQuery API - API for us to be able to create, manage, share and query data on your behalf.

Cloud Resource Manager API - Creates, reads, and updates metadata for Google Cloud Platform resource containers (Project)

IAM Service Account Credentials API - Creating service account on behalf of user. Identity and Access Management (IAM) API - Managing users on your behalf.

`Step One` - Create a Service Account key

In the Google Cloud, go to the Service Accounts page.
Select a project.
Click +Create Service Account and add the following 4 roles:

Project IAM Admin
Big Query Admin
Service Account Admin
Service Account Key Admin

Click the email address of the service account that you want to create a key for and click manage keys.

Click the Add key drop-down menu, then select Create new key.

Select JSON as the Key type and click Create.

Save the key for future reference.

For more info check out - Step by Step Guide

`Step Two`- Enter details on 5X

Service Account Key

Enter the service account key that you saved previously.

Project ID

The Project ID of your BigQuery instance.

To locate your project ID. Go to the API Console.
From the projects list, select Manage all projects. The names and IDs for all the projects you're a member of are displayed. You will find your project ID there.