
Explanation:
When reading from a Delta table's Change Data Feed (CDF), Databricks automatically appends metadata columns to the query results. The _change_type column indicates the type of change for each row. To find deleted records, you filter where _change_type = 'delete'. Other values include insert, update_preimage, and update_postimage.
Ultimate access to all questions.
No comments yet.