I'm looking for any pointers on how to have transactionally consistent output using cdc and Flink SQL. I'm not talking about at-least-once vs exactly-once. I want Flink to only stream output when the entire set of changes of a transaction have been processed. For example, see:
https://www.scattered-thoughts.net/writing/internal-consistency-in-streaming-systems/ It seems like this should be possible, as I could do it manually at the datastream level, but I can't find a single example anywhere which is troubling.