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

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

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

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

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

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.

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.

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.

Define how many rows to return.