Skip to main content
HTTP API connector An HTTP API described by an OpenAPI spec, not an MCP server. Calls go to https://bigquery.googleapis.com/bigquery/v2 and carry an OAuth 2.0 token obtained with Sign in with Google on the cloud edition, or an API key or custom header on a self-hosted installation, which offers no sign-in flow.

​
What the skill can do

API connector: 36 actions, as they appear in the skill panel. 21 of them create, change or delete something in BigQuery; mark those under These actions need approval when you add the skill to an agent.
  • Table management (7): Big Query Table5ee0 Management Create New Table5ee0, Big Query Table5ee0 Management List Table5ee0 Data, Big Query Table5ee0 Management Patch Table5ee0 Properties, Big Query Table5ee0 Management Update Entire Table5ee0, Big Query Table5ee0 Management Delete Table5ee0 By Id, Big Query Table5ee0 Management Insert Row5ee0s Into Table5ee0, Big Query Table5ee0 Management Get Table5ee0 Details
  • Query service (6): Big Query Project Management List All Projects, Big Query Dataset5ee0 Management List All Dataset5ee0s, Big Query Table5ee0 Management List All Table5ee0s, Big Query Query Service Get Query Results, Big Query Project Management Get Service Account, Big Query Query Service Run New Query
  • Dataset management (5): Big Query Dataset5ee0 Management Update Entire Dataset5ee0, Big Query Dataset5ee0 Management Create New Dataset5ee0, Big Query Dataset5ee0 Management Patch Dataset5ee0 Properties, Big Query Dataset5ee0 Management Get Dataset5ee0 Details, Big Query Dataset5ee0 Management Delete Dataset5ee0 By Id
  • Routine management (5): Big Query Routine5ee0 Management Get Routine5ee0 Details, Big Query Routine5ee0 Management Delete Routine5ee0 By Id, Big Query Routine5ee0 Management List All Routine5ee0s, Big Query Routine5ee0 Management Update Entire Routine5ee0, Big Query Routine5ee0 Management Create New Routine5ee0
  • Job management (5): Big Query Job5ee0 Management List All Job5ee0s, Big Query Job5ee0 Management Get Job5ee0 Details, Big Query Job5ee0 Management Create New Job5ee0, Big Query Job5ee0 Management Cancel Running Job5ee0, Big Query Job5ee0 Management Delete Job5ee0 By Id
  • Model management (4): Big Query Model5ee0 Management Get Model5ee0 Details, Big Query Model5ee0 Management Patch Model5ee0 Properties, Big Query Model5ee0 Management Delete Model5ee0 By Id, Big Query Model5ee0 Management List All Model5ee0s
  • Access control service (4): Big Query Access Control Test Iam Permissions For Resource, Big Query Access Control List Row5ee0 Access Policies, Big Query Access Control Get Iam Policy5ee0 For Resource, Big Query Access Control Set Iam Policy5ee0 For Resource

​
Authentication Options

The simplest way to connect to BigQuery is by using xpander’s built-in authentication:
  1. In Xpander Chat, open the agent’s settings and click Add skill.
  2. Search for BigQuery and select it.
  3. Click Sign in with BigQuery.
  4. Grant xpander permission to access your account.
  5. Your BigQuery integration is now ready to use.

​
Give an agent the BigQuery skill

Once BigQuery is connected, any agent you can edit may be given the skill: open the agent’s settings, click Add skill, and choose BigQuery. The skill panel lists the BigQuery actions by group. Enable only the groups the agent needs, and mark the actions that should wait for a named person’s sign-off under These actions need approval. Which skills exist for your organization, and who may add them, is decided by your admins; see Skills.