Awesome ClickHouseData Visualization and Analysis

grafana/clickhouse-datasource

⭐ 221 TypeScript repository created 2021-11-12

The project "grafana/clickhouse-datasource" is an official Grafana plugin designed to enable querying and visualization of ClickHouse data within the Grafana platform. This plugin facilitates seamless integration between Grafana and ClickHouse, allowing users to create dashboards and perform data analysis using ClickHouse as the data source. It supports both the Native and HTTP transport protocols for communication with ClickHouse, providing flexibility in configuration and deployment. The plugin is compatible with various versions of Grafana, with specific versions recommended for different Grafana releases to ensure optimal functionality. Installation instructions are provided for both local and cloud-based Grafana instances, along with detailed configuration guidelines. Users are advised to set up a ClickHouse user with readonly permissions to ensure safe querying, as the plugin does not validate query safety. The configuration supports manual setup via the Grafana UI or automated provisioning through configuration files, enabling scalable and repeatable deployments. The plugin supports building queries using raw SQL or a query builder, with support for macros that simplify syntax and enable dynamic SQL generation. It offers various visualization options including time series, tables, logs, and traces. Time series visualizations require a datetime field, and multi-line time series can be created by returning multiple fields in a specific order. Logs and traces visualization panels are supported with specific query requirements, including integration with Open Telemetry Collector and ClickHouse exporter for trace data. Overall, this plugin enhances Grafana's capabilities by providing robust support for ClickHouse data sources, enabling users to leverage ClickHouse's powerful analytics engine within Grafana's rich visualization environment. It is suitable for users looking to monitor, analyze, and visualize large-scale data stored in ClickHouse with ease and flexibility.

https://github.com/grafana/clickhouse-datasource

analyticsclickhousedashboarddata-sourcegrafanahacktoberfesthttp-protocollogsmacrosnative-protocolpluginprovisioningqueryreadonly-usersqltime-seriestracesvisualization

Also in Data Visualization and Analysis

akvorado/akvorado

Akvorado is a flow collector, enricher, and visualizer that processes network flow data, enriches it with interface and geolocation information, and stores it in ClickHouse for real-time analysis and visualization.

clickvisual/clickvisual

ClickVisual is a lightweight log analytics and data visualization platform built on ClickHouse, designed for efficient log querying, analysis, and monitoring.

mr-karan/logchef

Logchef is a lightweight, high-performance log analytics platform built on ClickHouse, offering schema-agnostic querying, team-based access control, and easy deployment as a single binary.

Altinity/clickhouse-grafana

Altinity/clickhouse-grafana is a Grafana datasource plugin that enables seamless integration and visualization of ClickHouse data within Grafana dashboards.

serenedb/serenedb

SereneDB is a distributed real-time search analytics database that unifies Elasticsearch-like search and ClickHouse-like analytics in a single, Postgres-compatible platform for high performance and ease of use.

iamtelescope/telescope

Telescope is a web-based log viewer UI that enables intuitive exploration and analysis of log data stored primarily in ClickHouse, with support for Docker logs and advanced querying features.

ClickHouse/metabase-clickhouse-driver

A ClickHouse database driver enabling integration with the Metabase business intelligence front-end for data visualization and querying.

ClickHouse/adsb.exposed

An interactive platform for visualizing and analyzing massive ADS-B air traffic data using ClickHouse with real-time querying and detailed visualizations.