Google Big Query

​

Connect AI Squared to BigQuery

This guide will help you configure the BigQuery Connector in AI Squared to access and use your BigQuery data.

​

Prerequisites

Before you begin, you’ll need to:

1. Enable BigQuery API and Locate Dataset(s):

   • Log in to the Google Developers Console.
   • If you don’t have a project, create one.
   • Enable the BigQuery API for your project.
   • Copy your Project ID.
   • Find the Project ID and Dataset ID of your BigQuery datasets. You can find this by querying the INFORMATION_SCHEMA.SCHEMATA view or by visiting the Google Cloud web console.

2. Create a Service Account:

   • Follow the instructions in our Google Cloud Provider (GCP) documentation to create a service account.

3. Grant Access:

   • In the Google Cloud web console, navigate to the IAM & Admin section and select IAM.
   • Find your service account and click on edit.
   • Go to the “Assign Roles” tab and click “Add another role”.
   • Search and select the “BigQuery User” and “BigQuery Data Viewer” roles.
   • Click “Save”.

4. Download JSON Key File:

   • In the Google Cloud web console, navigate to the IAM & Admin section and select IAM.
   • Find your service account and click on it.
   • Go to the “Keys” tab and click “Add Key”.
   • Select “Create new key” and choose JSON format.
   • Click “Download”.

​

Steps

​

Authentication

Authentication is supported via the following:

• Dataset ID and JSON Key File

  • Dataset ID: The ID of the dataset within Google BigQuery that you want to access. This can be found in Step 1.
  • JSON Key File: The JSON key file containing the authentication credentials for your service account.

​

Supported sync modes