Merge using DLT
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-11-2025 02:13 AM
I have a requirement where i need only 24 hours data from my delta table
lets call this as latest table
this latest table should be in sync with source
so, it should handle all updates and inserts along with delete (if something gets deleted at source, then it should be deleted at target)
any approach for this , we are looking for a solution in context of DLT
i am using create_auto_cdc but this is into taking care of deletes
apply_as_deletes is only taking care of coming data, but not exisitng data