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.
Awesome ClickHouse › Data Visualization and Analysis
ClickHouse/metabase-clickhouse-driver
The project "ClickHouse/metabase-clickhouse-driver" is a database driver designed specifically for integrating the ClickHouse database with the Metabase business intelligence front-end. This driver enables Metabase users to connect to ClickHouse, a high-performance columnar database management system, allowing them to leverage Metabase's powerful data visualization and querying capabilities on ClickHouse data. The driver supports stable and long-term support (LTS) releases of ClickHouse, with full compatibility for versions 23.8 and above, and best-effort support for versions 23.6 to 23.7. It also supports advanced features such as connection impersonation starting from ClickHouse version 24.4, enhancing security and user management. However, some features like CSV uploads currently work only with ClickHouse Cloud. Installation is straightforward, with options to run the driver using a Metabase jar file or as a Docker container. The project provides detailed instructions for both methods, including version compatibility guidelines to ensure the driver version matches the Metabase release version. Additionally, there is a convenience script to build a custom Docker image that bundles Metabase with the ClickHouse driver. The driver supports secure connections using SSL certificates, with configuration options for specifying certificate paths and enabling secure connections in Metabase. Operational recommendations include creating a dedicated read-only user for Metabase in ClickHouse, aligning time zones between Metabase and ClickHouse to avoid issues, and verifying query results against the native ClickHouse client. Known limitations include the exclusion of columns with AggregateFunction types due to JDBC driver constraints, potential issues with date/time filters on DateTime64 columns in older ClickHouse versions, and compatibility fallbacks for string filtering functions that may affect non-Latin string filtering accuracy. Overall, this project facilitates seamless integration between ClickHouse and Metabase, enabling users to explore, visualize, and share ClickHouse data effectively through Metabase's user-friendly interface.
https://github.com/ClickHouse/metabase-clickhouse-driver
Also in Data Visualization and Analysis
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/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.