Google BigQuery Connector Guide

When you open the BigQuery Connector you should see the fields as shown above. This guide will show you how to obtain all of the credentials to fill in the fields.

For the Dataset and Project ID the values must be exactly the same as it is in your Google Cloud Console

Dataset ID

In your Google Cloud Console:

1. Go to BigQuery

2. Copy the name of a dataset such as

   

3. Type or paste the name of the dataset into Perceptif

Project ID

In your Google Cloud Console:

1. In the navigation bar at the top of the screen you should see a small box to the right of the Google Cloud logo as shown below

   

2. The box lists out all of the existing projects available to you, when you have the name of your project type it into Perceptif

Credentials JSON

Specifically to create a Service Account key that has the BigQuery User and BigQuery Data Editor roles.

1. In Google Cloud Console navigate to APIs and Services → Credentials

2. Under Credentials there is a category called Service Accounts

3. Click “Create Credentials” a button at the top of the page

4. Click Service Account

5. Enter the service account details

6. When presented with optional roles for the service account

   1. Search and select BigQuery User

   2. Search and select BigQuery Data Editor

      

7. When the Service Account is Created you should open the service account by clicking on it

8. Go to the Keys tab

9. Create a Key with JSON

10. A JSON file will be downloaded

11. Open the file and copy all of its contents

12. Paste it into Perceptif

Save the JSON Credentials, it can be used for multiple connectors in Perceptif

Links for additional information

https://cloud.google.com/bigquery/docs/quickstarts/query-public-dataset-console#create_a_dataset

https://cloud.google.com/iam/docs/service-account-overview

https://cloud.google.com/iam/docs/keys-create-delete