Google BigQuery - Job completed trigger

The Job completed trigger polls regularly for jobs completed in Google BigQuery. This trigger can be configured to listen on various levels, from entire projects to individual tables. This trigger only picks up completed jobs.

Job completed trigger

Input

Input field	Description
Project	Select the project to monitor.
Dataset	Optional. Select the dataset to monitor.
Table	Optional. Select the table to monitor.
All users	Select an option from the list. Defaults to No. If Yes, all jobs will be listened on including those not pegged to the user. The user is the user who authorized the Google BigQuery connection.
When first started, this recipe should pick up events from	Provide a time to retrospectively pick up jobs from. Learn more about this input field.
Job Type	Provide a job type. Leave blank to listen on all jobs. When configured, it will only trigger on jobs that match.

Output

Output field	Description
ID	The ID of the job completed.
Kind	The type of the Google BigQuery job.
Job Reference	Contains information about the job such as Project ID, Job ID, and Location.
State	State of job. Must be DONE.
Statistics	Contains information about the query time and total bytes processed by the job.
Configuration	Contains information about the query configuration.
Status	Contains error results and messages if any.
User email	Email of the user who ran the job.