Analytics & Data
Connect Google BigQuery to Your AI Agents
Enable your Wkil agents to run SQL queries, browse datasets and schemas, and insert data through a secure Google BigQuery integration.
Authentication: OAuth 2.0
What you can do
- Run SQL queries against warehouse data
- Browse datasets, tables, and schemas
- Insert new rows into tables
Available capabilities may vary by authentication and workspace configuration.
Actions supported by the connector
Query
Run a SQL query against BigQuery data.
List BigQuery Datasets
List datasets available in a project.
Get BigQuery Table Schema
Retrieve the column schema for a table.
List BigQuery Table Data
Retrieve rows of data from a table.
Insert Data into BigQuery Table
Insert new rows into a table.
Practical agent use cases
- An agent runs a query to summarize last month's revenue by region.
- An agent inserts newly collected data into a warehouse table on a schedule.
How it works with Wkil
- 1Choose the integrationAdd Google BigQuery to your agent from inside the Wkil platform.
- 2Grant the permissions it needsDefine precisely what the agent can access and perform.
- 3Test, then run itTest actions before they go live, with human approval where needed.
Permissions always stay in your control — you can scope access and require human approval before any sensitive action.
Related integrations
FAQ
Can queries be scoped to specific datasets?
Yes — access follows the permissions of the connected Google account or service account.