Salesforce Connector SCD2 - Get new record with isDeleted = true on deletion

AcrobaticMonkey
New Contributor III

Hi all,

I'm using the Databricks Salesforce connector to ingest tables with history tracking enabled (SCD Type 2).

When records are deleted in Salesforce, the connector closes the existing record by setting the end date. The isDeleted flag remains false for all records.

Rather than just closing the record, I want a new record to be inserted with isDeleted = true.

Is there a configuration option to achieve this?

Thanks!