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
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
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
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
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.
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