Alter table add/drop column PostgreSql

[tellienne]

Hi!
We are trying to use sink-connector-lightweight to replicate data from PostgreSQL to Clickhpuse. Does it support ddl with postgresql (add, drop column)?
We made an alter in the postgres table (ALTER TABLE table_name ADD COLUMN) but in the clickhouse the table did not change

[subkanthi]

Hi @tellienne ,
Currently, the sink-connector lightweight version does not support replication of DDL's in PostgreSQL.
This comes from the limitations in logical decoding feature
https://debezium.io/documentation/reference/stable/connectors/postgresql.html

Logical decoding does not support DDL changes. This means that the connector is unable to report DDL change events back to consumers.

[tellienne]

Well, we will make alters manually in clickhouse :)
Thank you!