Support for Grafana ClickHouse Datasource with OpenTelemetry servicegraph connector

[Wudadada]

Description:

Hello team,

I would like to request support for using the servicegraph connector from OpenTelemetry Collector in conjunction with Grafana’s ClickHouse datasource. This integration would allow for easy visualization of service topology maps within Grafana, using data stored in ClickHouse as a source for the servicegraph connector.

Context and Use Case:

In our current setup, we rely on ClickHouse as a primary data source in Grafana. We aim to utilize the servicegraph connector to automatically generate service dependency maps based on OpenTelemetry traces, then visualize these directly in Grafana through ClickHouse. The ability to seamlessly connect the servicegraph connector with ClickHouse would streamline the observability workflow, allowing us to manage service relationships and performance metrics in one centralized location.

Proposed Solution:

•	Enable support for ClickHouse within the servicegraph connector, either by adjusting output compatibility or allowing a plugin-based approach for custom data storage solutions.
•	Alternatively, introduce modifications to Grafana’s ClickHouse datasource or plugin capabilities, making it compatible with the data model output from servicegraph connector.

Example Configuration:

An example of a configuration setup we envision might look like:

•	OpenTelemetry Collector configured to process traces and service topology via servicegraph connector.
•	Data is then exported directly into ClickHouse in a format compatible with Grafana’s visualization tools.

We believe this integration would greatly benefit those leveraging both OpenTelemetry and Grafana with ClickHouse, providing a powerful and efficient observability toolset.

Thank you for considering this feature! Looking forward to your feedback and any suggestions on how we might achieve this integration.

[Wudadada]

grafana/tempo's service graph: https://github.com/grafana/tempo/tree/main/modules/generator/processor/servicegraphs
opentelemetry-collector-contrib's service graph connector: https://github.com/open-telemetry/opentelemetry-collector-contrib/tree/main/connector/servicegraphconnector