Skip to main content

BigQuery User Connector Setup Guide

To integrate BigQuery with Abacus.AI, you need to set up the connector and provide the necessary permissions.

Prerequisites​

Before you begin, make sure you have followed the instruction of Bigquery setup guide for connector creation.

Build a ChatLLM project on your connector​

Create the project​

  1. From the Abacus.AI logo, go to the Projects page.
  2. Create a new project.
  3. Select ChatLLM – Custom LLM Chat.
  4. Enter a name for your project.
  5. Choose Skip to project dashboard.

Train the model​

  1. In the left toolbar, open Model and click Train Model (top right).
  2. For Structured data source, select External service from the dropdown.
  3. Choose the Bigquery connector you created in the steps above and add the tables to use for testing.
  4. Click Train Model.
  5. Once training completes, open Models and select your model.

Deploy and test​

  1. Click Create a new deployment.
  2. Select Offline Batch + Realtime, then click Next.
  3. Enter an end‑user friendly deployment name and click Deploy.
  4. Return to your model (Model > your model name). When the deployment is Active, click the deployment name.
  5. Under Deployment, open the Prediction Dash.
  6. Click Go to Abacus.AI chat to test your bot.

End‑user sign‑in​

  1. Enter your prompt/question. Each user will be asked to sign in once via Google auth. Log in using your user credentials.