support for timescaledb(postgres variant) - Added in Debezium 2.4.0

[subkanthi]

A request from a user in altinitydb

https://debezium.io/blog/2024/01/11/Debezium-and-TimescaleDB/

[salisbury-espinosa]

but it seems like everything is working as is...
timescaledb - it's just an extension - so it all work

TimescaleDB is an extension for PostgreSQL that enables time-series workloads, increasing ingest, query, storage and analytics performance.

[salisbury-espinosa]

there is a tricky setup of the data transfer from the postgresql itself to Kafka, because in timescale there is no native partitioning - but chunks - physical tables and there the timescale itself and the publication during logical replication must be cunningly, but very simply configured.
and this only concerns the setup of the postgres link to Kafka via Debezium.
and does not concern the sinker (simply because the sinker works with Kafka in Debezium format and it does not concern itself with how the data gets to this very Kafka).
and these are 5 lines of settings and do not affect the code of "clickhouse-sink-connector" in any way

by the way, the sinker works only in the original Debezium format - for example, you can't use such settings as:

transforms=unwrap,...
transforms.unwrap.type=io.debezium.transforms.ExtractNewRecordState

because the sinker expects a specific data format:

https://github.com/Altinity/clickhouse-sink-connector/blob/develop/sink-connector/src/main/java/com/altinity/clickhouse/sink/connector/model/SinkRecordColumns.java