---
title: "ClickStack SQL Charting and Alerting"
description: "ClickStack introduced SQL-based visualizations and SQL-based alerting to allow users to build charts and alerts using arbitrary ClickHouse SQL queries. Traditional query builders trade analytical flexibility for simplicity, preventing teams from easily expressing multi-stage computations like rolling baselines, anomaly detection, or dynamic SLO calculations. To maintain interactivity within dashboards, the system supports ClickHouse query parameters and macros that inject active time ranges, interval sizes, dashboard filters, and source tables. Furthermore, SQL-based alerting evaluates the numeric columns output by these queries, such as returning binary flags when values exceed statistical boundaries. By shifting computational logic directly into SQL, teams can implement complex operational checks without relying on static external thresholds."
---

# ClickStack SQL Charting and Alerting

[Clickhouse](https://yomu.fyi/company/clickhouse) · Drew Davis, Dale McDiarmid · May 13, 2026

**Type:** Announcement

## Summary

ClickStack introduced SQL-based visualizations and SQL-based alerting to allow users to build charts and alerts using arbitrary ClickHouse SQL queries. Traditional query builders trade analytical flexibility for simplicity, preventing teams from easily expressing multi-stage computations like rolling baselines, anomaly detection, or dynamic SLO calculations. To maintain interactivity within dashboards, the system supports ClickHouse query parameters and macros that inject active time ranges, interval sizes, dashboard filters, and source tables. Furthermore, SQL-based alerting evaluates the numeric columns output by these queries, such as returning binary flags when values exceed statistical boundaries. By shifting computational logic directly into SQL, teams can implement complex operational checks without relying on static external thresholds.

## Context

Traditional predefined query builders restrict advanced observability teams because they cannot easily support complex calculations such as rolling averages, historical baselines, window functions, and statistical anomaly detection.

## Approach / What changed

ClickStack added native ClickHouse SQL charting and alerting with support for query parameters and macros like $\_\_filters and $\_\_sourceTable to dynamically bind dashboard state and execute custom analytical logic.

## Takeaways

- ClickStack now supports arbitrary ClickHouse SQL queries for building dashboards and alert rules.
- Macros such as $\_\_filters and $\_\_sourceTable mirror ClickHouse Grafana plugin conventions to ease query migration and preserve dynamic filtering.
- SQL-based alerts evaluate returned numeric query columns, enabling queries to compute rolling baselines and return binary flags directly to trigger alerts.

**Tags:** [Architecture](https://yomu.fyi/topic/architecture), [Monitoring](https://yomu.fyi/topic/monitoring), [Observability](https://yomu.fyi/topic/observability)

- Source: [Clickhouse](https://clickhouse.com/blog/clickstack-sql-charting-and-alerting)
- Source URL: https://clickhouse.com/blog/clickstack-sql-charting-and-alerting
- Ingested by Yomu: 2026-08-28T01:25:48.378Z

[Read original post](https://clickhouse.com/blog/clickstack-sql-charting-and-alerting)