AI Squared home page
Search...
⌘K
Ask AI
Book a Demo
Back to App
Back to App
Search...
Navigation
Data Sources
Google Big Query
Home
Getting Started
AI Activation
Data Movement
Deployment & Security
Support & FAQs
Product Updates
Introduction
Sources
Adding a Data Source
Data Sources
Amazon Redshift
Snowflake
Google Big Query
Databricks
PostgreSQL
Salesforce Consumer Goods Cloud
AWS Athena
ClickHouse
MariaDB
Oracle
S3
Databricks Model
AWS Sagemaker Model
SFTP
WatsonX.Data
Intuit QuickBooks
Firecrawl
Destinations
Business Applications
Data Modelling
Overview
SQL Editor
Table Selector
Data Syncs
Overview
Full Refresh
Incremental
Incremental - Cursor Field
On this page
Connect AI Squared to BigQuery
Prerequisites
Steps
Authentication
Supported sync modes
Data Sources
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:
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.
Create a Service Account:
Follow the instructions in our
Google Cloud Provider (GCP) documentation
to create a service account.
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”.
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
Mode
Supported (Yes/No/Coming soon)
Incremental sync
YES
Full refresh
Coming soon
Was this page helpful?
Yes
No
Suggest edits
Snowflake
Databricks
Assistant
Responses are generated using AI and may contain mistakes.