Click +Add under integrations
Click the Add button and select BigQuery.
Go to the IAM & Admin section of Google Cloud
And go to the Service Users sub-section
Create a new Service Account
Add a name that will tell you later what it is and click "Done"
Add Permissions
And create and download a JSON key
Go to the BigQuery Console
Select your DataSet and copy the ID of it
The ID is in the format of [PROJECT_ID].[DATASET_ID]
Use the first part of the DataSet ID, separated by a dot, as the Project ID. The second part is the Dataset ID. And copy in the contents of the JSON file for the secret key.
Test and Save your connection
Click Test Connection and resolve any issues before clicking Save Connection
Start creating data products!
Explore the creation of data products in DataLab for generating text-to-SQL queries on your BigQuery datasets. Enable MCP connections to integrate your data with chat clients like Claude, Cursor, and ChatGPT. For further information, refer to "Creating a Data Product.
