Only trigger for query jobs that reference the selected table. Leave blank for all query job results.

Only columns that are type `integer`, `bytes`, `int64`, `float`, `timestamp`, `date`, `datetime`, `numeric`, `bignumeric` are returned. 
 The column will be sorted in descending order. The latest row will be returned.

The unique column is used to determine if a row is new. For example if the unique column is `id` and the latest row has an id of 1, 
 then the next time the trigger runs, if the latest row has an id of 2, then the trigger will return the row with an id of 2.

The column to match against the value in the WHERE clause. The where clause will be `WHERE column = value`

The value to match against the column in the WHERE clause. The where clause will be `WHERE column = value`

Required if Sort By Column is selected. Choose whether to sort the values Ascending or Descending.

Define the SQL WHERE clause which will determine which data is returned.

The raw SQL query to run against the table.

The geographic location where the job should run. Must be a [supported location](https://cloud.google.com/bigquery/docs/locations) (e.g. `us-central1`.)

Rows must be an array of objects. Example [{'id': '1', 'name': 'Test'}, {'id': '2', 'name': 'Test2'}]

Insert all valid rows of a request, even if invalid rows exist. The default value is false, which causes the entire request to fail if any invalid rows exist.

The columns and values to update in the table row. Separate each column and value with a comma. Example: `column1=value1,column2=value2`

API docs for Google BigQuery are located here https://cloud.google.com/bigquery/docs/reference/rest/v2/

Requests can only be made to domains associated by this application. View [documentation](https://help.zapier.com/hc/en-us/articles/12899607716493) for more details.

These params will be URL-encoded and appended to the URL when making the request.

Authentication headers are included automatically

Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.

Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example, `{"foo": "bar"}` is perfectly valid.

BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.

Zapier Automation Platform

PRODUCTS

CAPABILITIES

By use case

By app

By team

By company size

How Zapier Zaps

How Zapier Uses AI

By team

Learn more

Get help

Zapier quick-start guide

Developer resources

Google BigQuery Integrations

Google BigQuery Help & Support

How to get started with Google BigQuery on Zapier

About Google BigQuery

Related categories