Posts

ClickHouse table graph tool

In this article, I will describe my tool clickhouse-table-graph for ClickHouse table dependencies visualization. Introduction I like ClickHouse a lot. If you like ClickHouse a lot you probably like create fast and reliable data pipelines by using different kinds of ClickHouse tables and materialized views. At some point of time, you may have a lot of tables and materialized views. So it could be hard to understand the dependencies between them.

Read more →

January 28, 2025

Dynamic TTL for ClickHouse tables

In this article, I will describe how to implement dynamic TTL for ClickHouse tables based on the value of a specific table column. This approach allows you to set different TTLs for different rows in the table. This can be useful when you need to store data in the table for different periods of time, depending on the value of a specific column. In order to implement dynamic TTL, we will use Dictionaries and User Defined Functions (UDFs).

Read more →

May 20, 2024