Cold start table schema

[Thierry Girod]

Hi guys me again with another topic,

hope you are all doing well and you can help us with that as well.

When there is a table in a Database that was only created but no records written, the EmbeddedEngine does not return a cdc record (of course). We normally inherit the schema from this cdc records (SourceRecord) in our app and faced now the cold start problem when no records are produced. 

Is there somehow a mechanism build in to get a single records that has only the table schema in it but no data? Or is there another way ?

Regards, 

[Chris Cranford]

Hi -

By default, the connector should have `include.schema.changes` enabled, which means that there should be a topic that is named the same as the `topic.prefix` created. This topic will contain all the captured table's column details. You can find details here [1] about the schema change topic, and it should generally be the same for all connectors except PostgreSQL which does not support schema changes.

Does that help solve your problem?

-cc

[1]: https://debezium.io/documentation/reference/stable/connectors/oracle.html#oracle-schema-change-topic

--
You received this message because you are subscribed to the Google Groups "debezium" group.
To unsubscribe from this group and stop receiving emails from it, send an email to debezium+u...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/debezium/d2f35d57-9bc5-459d-a0af-5bf27533e1b7n%40googlegroups.com.