Looking to do some Reverse ETL? Meltano has you covered. Take a look at how the Meltano team profits immensely from Reverse ETL: https://meltano.com/blog/reverse-etl-publishing-data-from-your-data-warehouse-to-slack/

Hello, thanks for sharing. However how do you apply this when you need data reconciliation ? The difficult part for Reverse ETL is to capture the change to the target to mak a synchronisation. Here if something wrong, it is not too bad to send twice the same messages to Slack. Do you have a strategy for this too ?

Yeah great question, came up as well while I was writing this one. I decided to scope that part out of the article. Meltano doesn't yet have good ways of dealing with this in general, but we do have a few open interesting issues. To cut it short: What we recommend right now is to test the hell out of stuff using env. (e.g. use a private Slack channel for int testing/ local apprise notifications for developing).