ClickHouse Grafana Plugin: SQL-less Exploration Arrives

Bridging SQL Power with Intuitive UX

The latest iteration of the ClickHouse Grafana plugin marks a significant step forward in democratizing access to powerful time-series data analysis. By prioritizing common workflows like log searching and service-level filtering, the plugin effectively lowers the barrier to entry for users who may not be SQL experts. The introduction of 'single-table mode' and 'compact query mode' is particularly noteworthy, as it streamlines the initial setup and daily investigation process. This focus on 'investigate by clicking, not typing' directly addresses the iterative nature of debugging and analysis, allowing users to rapidly drill down into their data without the cognitive overhead of constructing complex SQL queries. The inclusion of out-of-the-box OpenTelemetry dashboards further enhances immediate value, providing pre-built visualizations that are immediately useful for users leveraging this standard for observability.

However, while the plugin strives to make common cases SQL-free, it's crucial to acknowledge that the underlying power still resides in ClickHouse's SQL capabilities. The 'always one click away' philosophy for full SQL access is well-implemented, but the transition from a simplified interface to full SQL can still present a learning curve for novice users. The article mentions that compact query mode is currently scoped to single-table configurations, which, while a sensible starting point for iterative development, might limit its immediate applicability for users with more complex, multi-table data schemas. Future expansion of compact query mode to support such scenarios would be highly beneficial. Additionally, while performance improvements are mentioned, the true impact of these optimizations on extremely large datasets within ClickHouse will only be fully realized through real-world adoption and testing by a broad user base. The plugin's success hinges on its ability to maintain performance and responsiveness as data volumes grow, and its integration with ClickHouse's evolving architecture.

Key Points

• New 'single-table mode' simplifies data source configuration for log-focused use cases.
• 'Compact query mode' allows users to type log messages directly, with the plugin generating SQL queries.
• Enhanced log row expansion organizes OpenTelemetry attributes into collapsible Resource, Scope, and Log sections for easier filtering.
• Users can now filter directly on selected text within log messages.
• Out-of-the-box OpenTelemetry dashboards (Logs Explorer, Traces Explorer, Per-Service Deep Dive) are now included.
• New annotation and variable editors provide guided experiences, reducing the need for manual SQL writing for common dashboard scaffolding tasks.
• Improvements in schema introspection caching, trace-ID lookup, and Grafana 13 readiness enhance performance and reliability.
• Header forwarding now allows passing Grafana user identity to ClickHouse for advanced security and attribution.

---

📖 Source: What’s new in the ClickHouse Grafana plugin