We are trying to build solution , where customer data stored in one of RDBM database SQL server and we are moving this data to delta lake in medallion architecture and want to this to be near real time by using DLT pipeline.
Problem is that source tables rows gets updated , so our bronze delta table will also behave same ,so we can 't create Live table on top of this due to bronze table being updated.
What could be the solution ?
