Schema Change Behaviour

[night2201]

Hi @ismailsimsek

• I am testing schema change behavior with this case

After removal, these column values are populated with null value. columns are kept in the destination table, no change applied to destination table.

• My table in postgres
  
• After, drop column department in above table and insert new a record. However, when I check values of this column in Iceberg table. I find that they don't populate null value.
  

Additional question, will the destination table be deleted if the source table is deleted? Or do I have to delete it manually

[ismailsimsek]

@night2201 as you can see row id=22 got NULL departmen value. previous rows are untouched.

Additional question, will the destination table be deleted if the source table is deleted? Or do I have to delete it manually

you need to delete it manually

[ismailsimsek]

leaving here link to the documentation on schema change behavior https://github.com/memiiso/debezium-server-iceberg/blob/master/docs/DOCS.md#schema-change-behaviour