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