Hi there! Say I have an
Order table with a field
order_status, which holds a foreign key to the
OrderStatus lookup table, which contains the types of order statuses. When an Order’s status changes I would like Debezium to produce the change but replace the foreign key of
order_status with the value from the
OrderStatus lookup table. So instead of consumer’s just seeing an id for
order_status, they see the string value instead.
After some research I’ve not found a definitive answer to solve this. Is this possible using Debezium configuration, or any other method?
EDIT: I would do this in stream processing, but as
OrderStatuses is a static lookup table, it will not produce changes, so it don’t produce a stream. I also don’t want my streams processor to know how to map the foreign key to a string itself.