signoz-writing-clickhouse-queries
Write raw ClickHouse SQL for a SigNoz dashboard panel: timeseries, value, or table widgets that the builder UI cannot express (custom joins, window functions, regex extraction over log bodies, aggregations beyond builder syntax). Trigger when the user explicitly asks for a "ClickHouse query", a "raw SQL panel", a "custom SQL widget", or describes a SigNoz dashboard panel whose query needs SQL the builder cannot produce. Anchored to dashboard-panel SQL specifically. For ad-hoc data exploration that does not need to land in a panel, use signoz-generating-queries instead.
Pinned to revision c5ed827d8090, so it is the text this page describes rather than whatever the author pushed since.
Files
- skills/signoz-writing-clickhouse-queries/SKILL.md
- skills/signoz-writing-clickhouse-queries/references/clickhouse-logs-reference.md
- skills/signoz-writing-clickhouse-queries/references/clickhouse-traces-reference.md
Every link opens the file at its source, pinned to the revision this page describes.