Customize schema name before publishing to schema registry

[gd_accent]

Hello,

Is it possible to rename value/key schemas before publishing to schema registry (Confluent Schema Registry) ?

When replicating database tables (oracle) to kafka topics and activating metadata message publication to Confluent Schema Registry, it seems not possible to set custom schemas name.

All schema are published like this : source_db_schema.source_db_table-value and source_db_schema.source_db_table-key.

Expl : APP_DBA.TABLE1-value

Is there any internal parameters or transformation to change this behaviour ?

Thank you.

[EyalSilner · Accepted solution]

Hi,

You can simply go to Task Settings >> Target Metadata tab and set a new (global) schema name to the Target table schema field.

BTW, you cannot suppress the dot between the schema and the table name (so it is better to avoid including a dot in the new schema name). 

Hope it helps 🙂 

[gd_accent]

Hello,

Perfect just tested this and it works fine thank you.

As you said, we can just customize before the dot but in case of kafka endpoint, both topics and avro schemas are properly renamed.