Google BigQuery integration
Query, analyze, and stream data into Google BigQuery — the fully managed, serverless data warehouse.
Build it by describing it
Type a sentence like this and the copilot builds, validates and simulates the workflow.- Simulated before it goes live
- Fixes proposed when something breaks
- One credit per run
Triggers
Start a workflow when this happens- WHENNew 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.
- WHENUpdated 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.
- WHENQuery 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.
- WHENNew Job Completed
Triggers when any BigQuery job (query, load, copy, or extract) finishes. Returns the job metadata including status, type, and timing.
Actions
Then Calibra can do this for you- DORun a Query
Execute a SQL query on BigQuery and return the results as flat rows.
- DOCreate Row
Creates a single new row in a BigQuery table. Column fields are loaded from the table schema.
- DOCreate Rows
Creates new rows of data in a BigQuery table (accepts an array of row objects). Rows are available to query within seconds.
- DODelete Rows
Deletes one or more rows from a BigQuery table using a SQL WHERE condition.
- DOUpdate Row(s)
Updates one or more existing rows in a BigQuery table using SQL SET and WHERE expressions.
- DOFind 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.
- DOFind 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.
- DOGet 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.
- DOImport 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.
- DOCustom API Call
Make a custom API call to a specific endpoint.
Questions
Is the Google BigQuery integration free?
Yes. Google BigQuery is available on every Calibra plan, including the free plan, which needs no card.
How is Google BigQuery usage billed?
Calibra charges one credit per workflow run, however many steps it has. Steps that read from or write to this app do not cost extra.
Can I connect Google BigQuery without writing code?
Yes. Describe the process in plain words and the AI copilot builds the workflow with Google BigQuery for you. You can also use templates or the visual editor.
Describe your first process. Watch it run today.
Free plan, no card. One credit per run, however many steps it has.