Google BigQuery + Nerve

Find One Row

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

Get Rows for Job Completed

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

Run a Query

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

Create Row

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

Create Rows

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

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

Update Row(s)

Update Row(s). Updates one or more existing rows in a BigQuery table using SQL SET and WHERE expressions

Find or Create Record

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

Import Data

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

Custom API Call. Make a custom API call to a specific endpoint