Question

What happens to data in the destination if it is deleted from the source?

Environment

Connector: Iterable

Answer

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.