Record GitHub deployment statuses in Google BigQuery
Know what reached each environment without piecing together separate logs.
Trigger
New Deployment Status Created
Fires when a new status is created for a GitHub deployment.
Action
Query
Runs a SQL query in BigQuery, including statements that can modify data.
Why this helps
Deployment context gets scattered across pipelines, chats, and memory.
- Creates a release audit trail
- Makes incident review faster
Setup
Build it in a few focused steps.
- 1Connect GitHub and Google BigQuery to Notis once.
- 2Create a new automation in Notis.
- 3Tell Notis to save each deployment status transition for release reporting.
- 4Select New Deployment Status Created and choose the run-report channel.
Questions about this workflow
Which deployment states can appear?
GitHub deployment statuses include transitions such as pending, in progress, success, and failure.
When this happens · Trigger
Fires when a new status is created for a GitHub deployment.
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.