[ Business intelligence ]
Google BigQuery integration for your workflows.
Connect Google BigQuery to Collabase once and use 10 actions and 4 triggers in your workflows. No code needed, hosted in Switzerland.
Google BigQuery in Collabase
Connect Google BigQuery to Collabase once and use 10 actions and 4 triggers in your workflows. No code needed, hosted in Switzerland.
[ About the service ]
Query, analyze, and stream data into Google BigQuery — the fully managed, serverless data warehouse
How to connect it
- Open the integrations in the workspace settings.
- Choose Google BigQuery and connect your account.
- Add a trigger or an action to the workflow.
Google BigQuery triggers
| Name | Description | Fields |
|---|---|---|
| New RowChecks at intervals | 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 RowChecks at intervals | 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)Checks at intervals | Triggers when a BigQuery query job finishes successfully. Each flow run receives the job metadata and the result rows from that query. |
|
| New Job CompletedChecks at intervals | Triggers when any BigQuery job (query, load, copy, or extract) finishes. Returns the job metadata including status, type, and timing. |
|
Google BigQuery actions
| Name | Description | Fields |
|---|---|---|
| Run a Query | Execute a SQL query on BigQuery and return the results as flat rows |
|
| Create Row | Creates a single new row in a BigQuery table. Column fields are loaded from the table schema. |
|
| Create Rows | Creates new rows of data in a BigQuery table (accepts an array of row objects). Rows are available to query within seconds. |
|
| Delete Rows | Deletes one or more rows from a BigQuery table using a SQL WHERE condition. |
|
| Update Row(s) | Updates one or more existing rows in a BigQuery table using SQL SET and WHERE expressions. |
|
| 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. |
|
| 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. |
|
| Custom API Call | Make a custom API call to a specific endpoint |
+ 3
|
[ Business intelligence ]
Related integrations
Tools that often share a workflow.
Questions about Google BigQuery
What can I automate with Google BigQuery in Collabase?
Google BigQuery brings 10 actions and 4 triggers, for example Run a Query, Create Row, Create Rows, Delete Rows and 6 more. You combine them in a workflow without code and mix them with every other integration.
How do I connect Google BigQuery to Collabase?
You open the integrations in the workspace settings, choose Google BigQuery and connect your account once, using OAuth 2.0. After that all triggers and actions are available in the workflow.
Can Google BigQuery start a workflow?
Yes. Google BigQuery provides 4 triggers, for example New Row, Updated Row, Query Job Completed (With Row Data) and 1 more. The workflow runs as soon as the event happens.
Does the Google BigQuery integration cost extra?
No. All integrations are included in every licence, in the Isolated Cloud and in Self-Hosted operation. There is no module price.
Test it against your own content. A proof of concept is ready within days.
We set up an instance with your content and you test it against real workflows. In a first conversation we clarify scope, operating model and timing.