Awesome ClickHouseData Visualization and Analysis

Altinity/clickhouse-grafana

⭐ 774 Python repository created 2017-01-03

Altinity/clickhouse-grafana is a Grafana datasource plugin designed specifically for integrating ClickHouse as a backend database. This plugin enables users to connect Grafana dashboards directly to ClickHouse, facilitating powerful and flexible data visualization and monitoring capabilities. Originally developed by Vertamedia and maintained by Altinity since 2020, the plugin supports Grafana versions 4.6 and above, with ongoing updates to ensure compatibility with newer Grafana releases. The plugin provides access to ClickHouse via HTTP or HTTPS protocols, allowing secure and efficient communication with the database. It supports a wide range of features including query setup with a user-friendly interface, a raw SQL editor for custom queries, query formatting, and macros support to simplify query writing. Users can leverage additional functions, templates, and various visualization options such as table view, SingleStat view, histograms, logs, flamegraphs, and traces. Advanced features include ad-hoc filters, annotations, and alert support, making it suitable for real-time monitoring and alerting scenarios. The plugin also integrates with CHProxy, an optional proxy that enhances security by enabling HTTPS access, limits concurrency to prevent overloading ClickHouse, queues requests to manage bursts, and caches frequent query responses to optimize performance. The query setup interface allows users to select databases and tables, configure time filtering columns, and toggle between a graphical query builder and a raw SQL editor. The raw SQL editor supports syntax highlighting, function and macro information, and query formatting. Macros such as $table, $dateCol, $from, $to, and others help dynamically generate queries based on dashboard context and time ranges. Overall, Altinity/clickhouse-grafana is a comprehensive and robust plugin that bridges Grafana and ClickHouse, enabling users to create rich, interactive dashboards with efficient data querying and visualization capabilities tailored for ClickHouse's analytical database environment.

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

alertsanalyticschproxyclickhouseclickhouse-datasourcedashboarddata-visualizationdatasource-plugingrafanahttphttpsmacrosmonitoringquery-formattingsql-editor

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.

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.

mprove-io/mprove

Mprove is an open-source self-service Business Intelligence platform with version control, leveraging ClickHouse for high-performance data analytics and flexible deployment options.