Is it possible to create a stream that detects changes from 3 different tables?

ksqlDB
1

Is it possible to create a stream that detects changes on 3 different tables? For example, I have Table A which contains Ids for Table B and Table C. If I constructed my join query correctly. could I emit an event that contains Table A’s id if there was a change in Table B or C?

Table A

  • id
  • b_id
  • c_id
  • field_abc
  • field_xyz

Table B

  • id
  • foo

Table C

  • id
  • bar

I want a stream that will emit Table A id’s if there is any changes in any of those 3 tables. Is this possible?

For example, if fields field_abc, foo, or bar were to change, I want Table A’s id to be emitted to a stream.

2

This topic was automatically closed after 30 days. New replies are no longer allowed.