Google BigQuery

Connection Details

FieldDescription
Project IDYour Google Cloud project ID
DatasetBigQuery dataset name
Service Account KeyJSON credentials file for authentication

Setting Up

1

Go to Connectors → Database

Select BigQuery as the database type.
Selecting BigQuery
2

Provide credentials

Enter your dataset ID, project ID and upload your service account key JSON file.
BigQuery connection form
3

Test connection

Click Test Connection to verify.
Testing BigQuery connection
4

Select datasets and tables

Choose which datasets and tables to include.
Selecting BigQuery tables
5

Save

Your BigQuery data is now queryable in conversations.
Use a service account with BigQuery Data Viewer and BigQuery Job User roles for read-only access.