ClickStack now supports SQL-based charting and alerting, allowing users to write arbitrary ClickHouse SQL queries for dashboards and alert conditions. This moves beyond predefined query builders to enable advanced observability workflows like rolling baseline anomaly detection, statistical SLO calculations, and multi-signal correlation. SQL alerts can encapsulate full alerting logic in the query itself, returning a binary 1/0 to trigger alerts rather than relying on static thresholds. Dynamic query parameters and macros (compatible with Grafana's ClickHouse plugin conventions) keep dashboards interactive. The feature integrates with existing PagerDuty and Incident.io alert integrations.
Table of contents
Introduction #The first step: SQL-powered charting #The next step: SQL-powered alerting #Conclusion #Sort: