signoz-writing-clickhouse-queries

To write custom ClickHouse SQL for SigNoz dashboards, generate raw queries tailored for timeseries, value, or table panels. You must leverage pre-extracted columns and end queries with a SETTINGS clause for monitoring.

Use raw ClickHouse queries when the built-in SigNoz query builder cannot express the required data shape, such as when you need complex joins, window functions, or body text extractions on logs and traces.

Yes, you can filter logs and traces by resource attributes in ClickHouse SQL. The queries should leverage pre-extracted columns and documented resource-filter patterns to scope your dashboard panel data accurately.

The correct format for monitoring queries in SigNoz dashboards requires a SETTINGS clause at the end of your raw ClickHouse SQL. This ensures the database executes the log and trace queries with the intended monitoring configurations.

Yes, SigNoz supports table panels alongside timeseries and value widgets for log and trace data exploration. You can generate ad-hoc ClickHouse queries to populate these specialized dashboard panels with custom data shapes.

Custom ClickHouse queries may fail on SigNoz dashboards if they omit the mandatory SETTINGS clause or fail to use pre-extracted columns. Ensure your SQL leverages documented resource-filter patterns for logs and traces.