G
Google BigQuery
by Google LLC
Connect agents to BigQuery to run SQL analytics, load data, and manage datasets and tables.
DatabasesPaidAPI keydatabasedata-warehousesqlanalyticsgoogle-cloudbigdata
How agents use Google BigQuery
- ✓Query large datasets to generate business intelligence reports
- ✓Stream events and activity logs from agent workflows into BigQuery
- ✓Run complex aggregations to identify trends, cohorts, or anomalies
- ✓Join data across multiple tables to build enriched datasets
- ✓Answer natural language questions by translating them to SQL queries
Agent actions
Run QueryExecute a SQL query against BigQuery and return results
Inputs: query, useLegacySql, maxResults, queryParameters
Returns: rows, rowCount, schema, jobId, bytesProcessed
Insert RowsStream rows into a BigQuery table using the streaming insert API
Inputs: datasetId, tableId, rows, skipInvalidRows
Returns: insertedCount, errors, success
List DatasetsList all datasets in a BigQuery project
Inputs: filter
Returns: datasets, count
List TablesList all tables in a BigQuery dataset
Inputs: datasetId
Returns: tables, count
Get Table SchemaRetrieve the schema and metadata of a BigQuery table
Inputs: datasetId, tableId
Returns: schema, numRows, numBytes, createdAt
Example workflows
1
Executive dashboard
Agent queries BigQuery for weekly business metrics and generates summary reports
2
Event tracking pipeline
Agent streams product events into BigQuery for real-time analytics
About Google BigQuery
- Vendor
- Google LLC
- Pricing Always review details with the vendor
- Paid — On-demand queries: $5/TB after 1TB free/month. Storage: $0.02/GB/month active. Flat rate available.
- Authentication
- API key
- Rate limit Always review details with the vendor
- 300 requests / minute
- Compatible nodes
- AgentResourceInputOutput
Build an AI workflow with Google BigQuery
Use the Agentic Planner to design, visualize, and connect Google BigQuery with your other tools.
Open Agentic Planner