SigNoz stores all observability data in ClickHouse. You can write ClickHouse SQL queries directly to build custom dashboard panels and alerts when the visual Query Builder does not cover your use case.
ClickHouse queries are only supported in Dashboards. To write a ClickHouse query, go to Dashboards, create a new dashboard or open an existing one, add a new panel, and select the ClickHouse Query tab.
Signal-Specific Query Guides
Each signal type has its own schema and query patterns. Refer to the guide for the signal you want to query:
Query metrics data stored in ClickHouse, including schema reference and examples for timeseries, value, and table panels.
Query logs data stored in ClickHouse, including the logs schema and examples for filtering, aggregating, and visualizing log data.
Query traces data stored in ClickHouse, including the spans schema and examples for latency analysis, error tracking, and service dependency queries.