Google BigQuery integration

Query, analyze, and stream data into Google BigQuery — the fully managed, serverless data warehouse.

Data and analytics4 triggers · 10 actions

Build it by describing it

Type a sentence like this and the copilot builds, validates and simulates the workflow.
When “New Row” happens in Google BigQuery, check the details with AI, then “Run a Query” and tell my team in Slack.
  • Simulated before it goes live
  • Fixes proposed when something breaks
  • One credit per run

Triggers

Start a workflow when this happens
  • WHEN
    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.

  • WHEN
    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.

  • WHEN
    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.

  • WHEN
    New 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
  • DO
    Run a Query

    Execute a SQL query on BigQuery and return the results as flat rows.

  • DO
    Create Row

    Creates a single new row in a BigQuery table. Column fields are loaded from the table schema.

  • DO
    Create Rows

    Creates new rows of data in a BigQuery table (accepts an array of row objects). Rows are available to query within seconds.

  • DO
    Delete Rows

    Deletes one or more rows from a BigQuery table using a SQL WHERE condition.

  • DO
    Update Row(s)

    Updates one or more existing rows in a BigQuery table using SQL SET and WHERE expressions.

  • DO
    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.

  • DO
    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.

  • DO
    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.

  • DO
    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.

  • DO
    Custom 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.