The soft delete feature allows you to retain deleted source records in the target by enabling or disabling soft delete for selected datasets. You can configure soft delete for both newly created and existing tables, with specific steps for each scenario. An icon indicates which datasets have soft delete enabled, and you can remove the feature at any time through the interface.
Enabling Soft Delete for Datasets
-
On the source side, select the datasets you want to enable soft delete for.
-
Click the Soft delete button.
-
In the dropdown menu, choose Add soft delete for the selected datasets.
-
An Add soft delete dialog will appear, explaining the impact on both newly created and existing tables.
Created Tables
For tables that will be created:
- Soft delete is added automatically to the dataset.
- You can bulk name the soft delete field, which will be configured on the field mapping page for that dataset.
- If you map soft delete to an existing field, any data in that field will be overwritten by the soft delete process.
- If there is no boolean-type field available, you cannot add soft delete to the dataset.
Mixed Selection (Created and Existing Tables)
If you select a combination of created and existing tables, a modal will prompt you to complete the necessary actions for both scenarios.
Soft Delete Field Name Autofill
When adding soft delete to created datasets, the field name for soft delete is autofilled to streamline the process.
Disabling Soft Delete for Datasets
-
On the source side, select the datasets you want to remove soft delete from.
-
Click the Soft delete button.
-
In the dropdown menu, choose Remove soft delete for the selected datasets.
-
A Remove soft delete dialog will appear to confirm your action.
Important Notes
- Soft delete requires a boolean-type field in the target table.
- Overwriting an existing boolean field with soft delete will replace any current data in that field.
- Datasets with soft delete enabled are clearly marked with an icon in the table view.