Google BigQuery
Query, analyze, and stream data into Google BigQuery — the fully managed, serverless data warehouse
Connect it
In Keystile Automations → Connections → New connection, choose Google BigQuery and sign in. Your AI tools and workflows then use it through Keystile; they never see the password or key.How connecting works.
Try it from your AI tool
Using Keystile, in Google BigQuery: delete rows (Deletes one or more rows from a BigQuery table using a SQL WHERE condition).What it can do (10 actions)
| Action | What it does | Changes data |
|---|---|---|
| Create Row | Creates a single new row in a BigQuery table. Column fields are loaded from the table schema. | Yes |
| Create Rows | Creates new rows of data in a BigQuery table (accepts an array of row objects). Rows are available to query within seconds. | Yes |
| Custom API Call | Make a custom API call to a specific endpoint | Yes |
| Delete Rows | Deletes one or more rows from a BigQuery table using a SQL WHERE condition. | |
| Find One Row | Find a single row by specifying a WHERE clause and an optional ORDER BY. Returns the first matching row, or empty if none found. | |
| Find or Create Record | Searches for a row matching a WHERE clause. If found, returns it. If not found, inserts the provided row data and returns that. | Yes |
| Get Rows for Job Completed | Retrieves the result rows from a completed BigQuery query job by Job ID. Use this after a "Query Job Completed" trigger to fetch the full result set. | |
| Import Data | Imports a batch of rows into a BigQuery table. Accepts a JSON array or newline-delimited JSON (NDJSON). Large datasets are automatically split into chunks. | Yes |
| Run a Query | Execute a SQL query on BigQuery and return the results as flat rows | Yes |
| Update Row(s) | Updates one or more existing rows in a BigQuery table using SQL SET and WHERE expressions. | Yes |
Start a workflow when… (4 triggers)
- New Row — Triggers when a new row is added to a BigQuery table. Polls every 5 minutes by comparing the latest value in a sort column against the previous check.
- Updated Row — Triggers when an existing row is updated in a BigQuery table. Requires an `updated_at` TIMESTAMP column that is set whenever a row changes.
- Query Job Completed (With Row Data) — Triggers when a BigQuery query job finishes successfully. Each flow run receives the job metadata and the result rows from that query.
- New Job Completed — Triggers when any BigQuery job (query, load, copy, or extract) finishes. Returns the job metadata including status, type, and timing.
How Keystile protects it
Every Google BigQuery action is checked before it runs, whether it comes from an AI tool or a workflow. 7 of its actions change data; your rules, limits and budgets decide whether each is allowed, held for a person or stopped, and it all goes into the signed record.
Use Google BigQuery with your AI assistant — safelyClaude, Cursor or ChatGPT do the work; Keystile checks every action first.
Get early access