Use ClickHouse run analytics to cancel stale GitHub workflows
Find the runs your own data says need attention, then let Notis cancel eligible GitHub workflow runs.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Cancel a workflow run
Cancels a workflow run in a github repository if it is in a cancellable state (e.g., 'in progress' or 'queued').
Why this helps
Finding and stopping stuck or unwanted runs takes attention away from the work those runs are meant to support.
- Reduce manual checking of runs identified by your analytics.
- Act on a cancellation rule you specify in plain language.
- Keep scheduled run checks and reports in one Notis automation.
Setup
Build it in a few focused steps.
- 1Connect ClickHouse and GitHub in the Notis portal.
- 2Create an automation in Automations, New Automation, and name it.
- 3In one instruction, provide the query or table, the stale-run rule, and the repository and run identifiers to cancel.
- 4Pick a recurring schedule and choose where run reports go.
- 5Test with one real result row for a run that GitHub reports as queued or in progress.
Questions about this workflow
What information should the query return?
Return the repository and workflow run identifier, plus the data needed to decide that the run meets your cancellation rule.
Will this cancel any run returned by the query?
Describe the conditions clearly in your instruction. GitHub only permits cancellation when a run is in a cancellable state, such as queued or in progress.
Can ClickHouse tell whether a run is cancellable?
Only if the relevant status is in the data available to your query. GitHub rejects cancellation for runs that are not in a cancellable state.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link ClickHouse to GitHub. A trigger fires from one place; an action lands in another.
ClickHouse triggers
GitHub actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Accept a repository invitation
Accepts a pending repository invitation that has been issued to the authenticated user.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
List repositories starred by the authenticated user
Deprecated: lists repositories starred by the authenticated user, including star creation timestamps; use 'list repositories starred by the authenticated user' instead.
List stargazers
Deprecated: lists users who have starred a repository; use `list stargazers` instead.
Star a repository for the authenticated user
Deprecated: stars a repository for the authenticated user; use `star a repository for the authenticated user` instead.
Add email for auth user
Adds one or more email addresses (which will be initially unverified) to the authenticated user's github account; use this to associate new emails, noting an email verified for another account will error, while an existing email for the current user is accepted.
Add app access restrictions
Replaces github app access restrictions for an existing protected branch; requires a json array of app slugs in the request body, where apps must be installed and have 'contents' write permissions.
Add a repository collaborator
Adds a github user as a repository collaborator, or updates their permission if already a collaborator; `permission` applies to organization-owned repositories (personal ones default to 'push' and ignore this field), and an invitation may be created or permissions updated directly.
Add a repository to an app installation
Adds a repository to a github app installation, granting the app access; requires authenticated user to have admin rights for the repository and access to the installation.
Connect any two apps with Notis in the middle.
ClickHouse and GitHub, or any other combination from 1,000+ 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 GitHub.