Track GitHub pull request lifecycles in Google BigQuery
See delivery movement from opening to close without reconstructing it later.
Trigger
Pull Request Event
Triggers when a pull request is opened, closed, or updated with new commits.
Action
Query
Runs a SQL query in BigQuery, including statements that can modify data.
Why this helps
It is easy to lose the thread of work once several PRs move at once.
- Provides a full activity timeline
- Reduces status-chasing
Setup
Build it in a few focused steps.
- 1Connect GitHub and Google BigQuery to Notis once.
- 2Make a new automation in Automations.
- 3Write one instruction to save each pull request lifecycle event for reporting.
- 4Choose Pull Request Event and a channel for run reports.
Questions about this workflow
What events are captured?
The trigger covers pull requests opened, closed, and synchronized.
When this happens · Trigger
Triggers when a pull request is opened, closed, or updated with new commits.
Do this · Action
Runs a SQL query in BigQuery, including statements that can modify data.
Supported Triggers and Actions
Notis builds workflows that link GitHub to Google BigQuery. A trigger fires from one place; an action lands in another.
GitHub triggers
Google BigQuery actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Query
Runs a SQL query in BigQuery, including statements that can modify data.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Cancel BigQuery Job
Requests cancellation of a running BigQuery job; cancellation must be checked and may still incur costs.
New Workflow Artifact Created
Fires when a new GitHub Actions workflow artifact is created in a repository.
Create Capacity Commitment
Creates a capacity commitment to purchase BigQuery compute slots for a committed term.
Branch Changed
Fires when a branch’s commits or protection status or settings change.
Create BigQuery Connection
Creates a BigQuery connection to an external data source.
New Branch Created
Fires when a new branch is created in a GitHub repository.
Create Analytics Hub Listing
Creates an Analytics Hub listing; its dataset must exist in the exchange’s region.
Check Run Status / Conclusion Changed
Fires when a GitHub check run’s status or conclusion changes.
Create BigQuery Dataset
Creates a BigQuery dataset in a specified location.
Check Suite Status / Conclusion Changed
Fires when a GitHub check suite changes status or conclusion for a reference.
Create Analytics Hub Data Exchange
Creates an Analytics Hub data exchange for sharing BigQuery datasets.
New Code Scanning Alert Created
Fires when a new code scanning alert is created in a repository.
Create Analytics Hub Listing
Creates an Analytics Hub listing to publish a BigQuery dataset for subscription.
Connect any two apps with Notis in the middle.
GitHub and Google BigQuery, or any other combination from 1,500+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with $20 of usage included.
No card. Works with personal or business Google BigQuery.