Google BigQuery
Query, inspect, and write Google BigQuery projects, datasets, tables, jobs, and rows.
Tools
| Name | Description |
|---|---|
list_projectsList BigQuery projects available to the connected Google account. | List BigQuery projects available to the connected Google account. |
list_datasetsList datasets in a BigQuery project. | List datasets in a BigQuery project. |
get_datasetGet metadata for a BigQuery dataset. | Get metadata for a BigQuery dataset. |
list_tablesList tables, views, and external tables in a BigQuery dataset. | List tables, views, and external tables in a BigQuery dataset. |
get_tableGet BigQuery table metadata and schema. | Get BigQuery table metadata and schema. |
list_table_rowsList table rows with a capped page size and flattened BigQuery row objects. | List table rows with a capped page size and flattened BigQuery row objects. |
run_queryRun a BigQuery SQL query and return flattened rows, schema, job metadata, and pagination cursors. | Run a BigQuery SQL query and return flattened rows, schema, job metadata, and pagination cursors. |
get_query_resultsFetch or paginate rows for a completed or running BigQuery query job. | Fetch or paginate rows for a completed or running BigQuery query job. |
list_jobsList BigQuery jobs in a project for operational inspection and pagination. | List BigQuery jobs in a project for operational inspection and pagination. |
get_jobGet metadata, status, statistics, and errors for a BigQuery job. | Get metadata, status, statistics, and errors for a BigQuery job. |
cancel_jobRequest cancellation of a BigQuery job. BigQuery may still charge for work already performed. | Request cancellation of a BigQuery job. BigQuery may still charge for work already performed. |
insert_rowsStream up to 500 JSON rows into a BigQuery table with insertAll and return row-level insert errors. | Stream up to 500 JSON rows into a BigQuery table with insertAll and return row-level insert errors. |
custom_api_callCall a Google BigQuery REST API v2 path on bigquery.googleapis.com. | Call a Google BigQuery REST API v2 path on bigquery.googleapis.com. |
Quick Start
import { WeavzClient } from '@weavz-io/sdk'
const weavz = new WeavzClient({ apiKey: 'wvz_...' })
const result = await weavz.actions.execute('google-bigquery', 'list_projects', {
workspaceId: '550e8400-e29b-41d4-a716-446655440000',
integrationAlias: 'google-bigquery',
input: { /* ... */ },
})Related Integrations
Works well with
Frequently Asked Questions
How do I connect Google BigQuery to my app?
Use Weavz Hosted Connect for OAuth2 authentication. Install the SDK, create a connection through the connect portal or API, then execute tools programmatically.
What tools does Google BigQuery support?
Google BigQuery supports 13 tools including List Projects, List Datasets, Get Dataset, List Tables, Get Table, and more.
Can I use Google BigQuery with AI agents?
Yes. Add Google BigQuery to an MCP server in Tool Mode or Code Mode. Code Mode provides 3 meta-tools with on-demand API discovery so agents can compose stateful workflows without loading every action schema up front.
Can Google BigQuery be used in stateful agent workflows?
Yes. Agents can combine Google BigQuery tools with Filesystem, State KV, Human Gates, input partials, and other workspace integrations while keeping execution scoped to the selected workspace or end user.
What authentication does Google BigQuery use?
Google BigQuery uses OAuth2. Weavz stores OAuth credentials securely and refreshes tokens when supported by the provider.
How much does the Google BigQuery integration cost?
The Google BigQuery integration is included on all Weavz plans including the free tier with 20,000 actions per month. No credit card required.
Connect Google BigQuery in minutes
Get 20,000 free action executions every month. No credit card required.