Turn ClickHouse metric alerts into GitHub issue labels
Let a scheduled ClickHouse check flag issue-linked metrics and add the right existing or new GitHub labels for follow-up.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Add labels to an issue
Adds labels (provided in the request body) to a repository issue; labels that do not already exist are created.
Why this helps
Metric alerts can get lost when you have to switch tools, find the related issue, and label it by hand.
- Bring metric-driven work into the GitHub issues you already use.
- Reduce manual searching when an analytics threshold is crossed.
- Let Notis interpret query results and apply labels to matching issues.
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, threshold, issue identifiers, and the label to apply when a row matches.
- 4Pick a recurring schedule and choose where run reports go.
- 5Test with one real result row that includes a GitHub repository, issue number, and threshold-matching data.
Questions about this workflow
What does the ClickHouse query need to return?
It needs to return enough information to identify each GitHub repository and issue, along with the metric and threshold decision. Provide the query or relevant schema in your instruction.
Does the label have to exist already?
No. GitHub's add-label action creates labels that do not already exist in the repository.
Can Notis choose the threshold for me?
State the threshold or decision rule in your instruction. Notis can analyze returned data, but it cannot infer a business threshold you have not supplied.
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.