Connecting BigQuery

Click +Add under integrations

Click the Add button and select BigQuery.

Create a Google Cloud Service Account

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

Gather BigQuery DataSet Information

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]

Add Information to Alkemi

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.