Google Big Query

​

Connect AI Squared to BigQuery

​

Prerequisites

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

• 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