Learn how to build AI agents with Google BigQuery access using xpander.ai. Create powerful data-driven AI assistants that can query, analyze, and manage large-scale datasets in real time to automate insights, reporting, and decision-making.

Authentication Options

Choose the authentication method that best fits your needs:

BigQuery API access configuration

For programmatic access and automation:

  1. You will need access to the Google Cloud CLI tool in order to get your token. If you have it installed, continue to step 5.

  2. Download Google Cloud’s CLI tool

  3. Run the installation script from the directiry where you downloaded and extracted the content of the SDK: ./google-cloud-sdk/install.sh

  4. After installing the SDK, update your $PATH to include the bin folder under the SDK (export PATH="$PATH:$HOME/Downloads/google-cloud-sdk/bin").

  5. To initialize the gcloud CLI, run gcloud init: ./google-cloud-sdk/bin/gcloud init

  6. Run the following command, and copy the token it generates: gcloud auth print-access-token

Let’s create the Xpander.ai Google BigQuery interface!

Write your interface name, select the interface access you’d like, Select the API key authentication method, and then paste the token copied earlier in the API Key field, and select Bearer as the Auth type, like so:

Then save the interface.

For more information about the Google API enablement, click here.