What happens to data in the destination if it is deleted from the source?
For tables that capture deletes as per Iterable Documentation, the data will be present in the destination but we will add an extra column named
_fivetran_deleted to the table and mark the rows as
TRUE for deleted data.
Tables that don't capture deletes will have the deleted data in the destination, but there will be no column pointing out that data is deleted.