Turn ClickHouse metric anomalies into Linear issues
Find the metric changes worth investigating and give them a clear place in the team's backlog.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Create linear issue
Creates a new issue in a specified linear project and team, requiring a title and description, and allowing for optional properties like assignee, state, priority, cycle, and due date.
Why this helps
Unexpected metric changes can get buried in dashboards while someone remembers to write them up and assign follow-up.
- Surface notable changes from scheduled ClickHouse checks.
- Create a focused issue with the query evidence and suggested investigation.
- Reduce manual dashboard review and issue drafting.
Setup
Build it in a few focused steps.
- 1Connect ClickHouse and Linear once in the Notis portal.
- 2Create an automation in Automations, New Automation, or tell Notis the desired outcome in plain language.
- 3In one instruction, ask Notis to review a ClickHouse metric query for unusual changes and create a Linear issue only when it finds a meaningful anomaly, including the evidence and investigation context.
- 4Pick a recurring schedule as the trigger and choose where run reports should go.
- 5Test with one real query result and confirm the issue is useful.
Questions about this workflow
Does this automation detect a statistically significant anomaly?
Only if the query or the supplied criteria support that conclusion. Describe the comparison or threshold you want Notis to use; otherwise it can summarize unusual values without claiming statistical significance.
What if a query returns no anomaly?
Tell Notis to skip issue creation when there is no meaningful change and report the check result.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link ClickHouse to Linear. A trigger fires from one place; an action lands in another.
ClickHouse triggers
Linear actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create linear attachment
Creates a new attachment and associates it with a specific, existing linear issue.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create a comment
Creates a new comment on a specified linear issue.
Create linear issue
Creates a new issue in a specified linear project and team, requiring a title and description, and allowing for optional properties like assignee, state, priority, cycle, and due date.
Get create issue default params
Fetches a linear team's default issue estimate and state, useful for pre-filling new issue forms.
Create a label
Creates a new label in linear for a specified team, used to categorize and organize issues.
Delete issue
Archives an existing linear issue by its id, which is linear's standard way of deleting issues; the operation is idempotent.
Get all teams
Retrieves all teams from the linear workspace without requiring any parameters.
Download issue attachments
Downloads a specific attachment from a linear issue; the `file name` must include the correct file extension.
Connect any two apps with Notis in the middle.
ClickHouse and Linear, 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 Linear.