{"repo":"mbaksheev/clickhouse-table-graph","free":true,"listed":false,"github":"https://github.com/mbaksheev/clickhouse-table-graph","clone":"git clone https://github.com/mbaksheev/clickhouse-table-graph.git","description":"Tool for visualizing dependencies between ClickHouse tables.","language":"Go","stars":21,"topics":["clickhouse","database","dependencies","go","graph","visualization","mermaid"],"license":"MIT","category":"databases-storage","readme_excerpt":"ClickHouse table graph Tool for visualizing dependencies between ClickHouse tables. Table of contents - Overview - How to use - CLI application - Pre-requisites - Build and run - Packages - cmd/chtg-cli main package - table package - clickhouse package - graph package - mermaid package Overview The main goal of this tool is to visualize ClickHouse table dependencies. When you have big number of tables in your ClickHouse database, it can be really hard to understand how they are connected and what is the data flow between them. With this tool you can easily visualize tables dependencies and understand the data flow in your ClickHouse database. Thanks to mermaid, an awesome tool for generating diagrams, the resulting graph looks attractive and can be easily added to your markdown documentation. Current version of the tool extracts dependencies from: create table query column in system.tables table: Materialized view Target table is extracted from the TO clause of the create query Joined tables are extracted from the JOIN clause of the create query, if materialized view select query contains JOIN clause Distributed table is extracted from the Distributed engine definition in the create query Dictionary is extracted from the dictionary functions like dictGet , dictGetString , dictGetUInt64 in the create query dependencies table column in system.tables This tool is written in Go and functionality is well split into separate packages, so it can be easily integrated into other Go pr","default_branch":null,"files":null,"tree":[],"storefront":"/r/mbaksheev","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/mbaksheev/clickhouse-table-graph/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}