Kafka sink: dynamic topic name

[maingoh]

Is your feature request related to a problem? Please describe.

I would like to choose the topic name depending on the value of a column. This way I can have consumers A consuming topic A and doing something specific, and have consumer B consuming topic B and doing something else.
Both are totally exclusive, consumer A doesn't need to process topic B and vice-versa.

Describe the solution you'd like

A bit like #15835.
It looks however that there is a limitation in the documentation One sink can only correspond to one topic.

Describe alternatives you've considered

No response

Additional context

No response

[neverchanje]

Thanks for providing this interesting requirement!
I've noted it down. May I ask if it's currently blocking your PoC?

[maingoh]

It is not yet blocking as we already have a "big topic" and filter on the consumer side if it needs to process the message or not, however most of the time they will ignore it. If each of them had dedicated topic it would be more efficient :)