DLT - SCD 2 - detect deletes

dalcuovidiu
New Contributor III

Hello,

I have a question related to APPLY AS DELETE WHEN...
If the source table does not have a column that specifies whether a record was deleted, I am currently using a workaround by ingesting synthetic data with a soft_deletion flag. 

In the future, there will be updates to automatically handle deletes?  For me, a delete means that an id does not exist in the bronze table but still exists in the target (silver or gold).

I’m curious to know how other teams are handling this scenario. Do you implement similar workarounds, or do you have another best practice for managing deletes in Delta Live Tables?