Connect Google BigQuery to GitHub Copilot
Give GitHub Copilot 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 GitHub Copilot in four steps
Admins approve the server once. Everyone in GitHub Copilot 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 GitHub Copilot to Runlayer
GitHub Copilot gets connector tools through the Runlayer Plugin, and reaches Google BigQuery’s 9 tools through the plugin’s search and execute tools.
GitHub Copilot 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 GitHub Copilot
Google BigQuery’s approved tools appear in GitHub Copilot. Every call is checked against policy and recorded.
Tools
9 Google BigQuery tools in GitHub Copilot
Runlayer policy decides which of these GitHub Copilot 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 GitHub Copilot
Some controls apply to every client at the gateway. Others depend on what GitHub Copilot exposes to Runlayer.
Gateway policy (available)
Every Google BigQuery call from GitHub Copilot passes through Runlayer, where your policies can allow, alert, mask, or block it.
Audit trail (available)
Each call is recorded with the user, GitHub Copilot as the client, the tool, and the policy and scanner decisions.
Native enforcement adapter (not available)
Runlayer has no device-side adapter for GitHub Copilot yet, so control happens at the gateway.
Frequently asked questions
Connect more