Skip to main content

Connect Google BigQuery to ChatGPT

Give ChatGPT governed access to Google BigQuery’s 9 tools through Runlayer, with identity, policy, scanning, and audit on every call.

Set up

Add Google BigQuery to ChatGPT in four steps

Admins approve the server once. Everyone in ChatGPT then gets it through the same governed connection.

  1. 1

    Approve Google BigQuery in Runlayer

    Add Google BigQuery from the catalog and choose who can use it and which of its tools are allowed.

  2. 2

    Connect ChatGPT to Runlayer

    Admins publish the Runlayer Plugin and its skill to the whole ChatGPT organization. With direct tool listing turned on for your deployment, Google BigQuery’s 9 tools show up in ChatGPT’s own tool list.

    ChatGPT setup guide
  3. 3

    Sign in to Google BigQuery

    Each user signs in to Google BigQuery with OAuth. Runlayer keeps the tokens out of the client’s configuration.

  4. 4

    Use Google BigQuery from ChatGPT

    Google BigQuery’s approved tools appear in ChatGPT. Every call is checked against policy and recorded.

Tools

9 Google BigQuery tools in ChatGPT

Runlayer policy decides which of these ChatGPT users can call.

  • Cancel job

    Cancel a running BigQuery job.

  • Execute SQL

    Run a SQL query in the project and return the result.

  • Execute SQL readonly

    Run a read-only SQL query in the project and return the result.

  • Get dataset info

    Get metadata information about a BigQuery dataset or BigLake namespace.

  • Get job

    Get information and status about a BigQuery job.

  • Get query results

    Get the results of a BigQuery SQL query job.

  • Get table info

    Get metadata information about a BigQuery table or BigLake table.

  • List dataset IDS

    List BigQuery dataset IDs and BigLake namespaces in a Google Cloud project.

See all 9 Google BigQuery tools

Control

What Runlayer can see and stop in ChatGPT

Some controls apply to every client at the gateway. Others depend on what ChatGPT exposes to Runlayer.

  • Gateway policy (available)

    Every Google BigQuery call from ChatGPT passes through Runlayer, where your policies can allow, alert, mask, or block it.

  • Audit trail (available)

    Each call is recorded with the user, ChatGPT as the client, the tool, and the policy and scanner decisions.

  • Compliance API import (available)

    OpenAI Compliance Logs Platform imports ChatGPT web chats for review.

  • Managed browser extension (available)

    Managed Chrome, Edge, and Firefox deployments can monitor supported web-chat activity and apply prompt-time controls where the surface permits it.

  • Native enforcement adapter (not available)

    Runlayer has no device-side adapter for ChatGPT yet, so control happens at the gateway.

Frequently asked questions

Connect more

Find another combination