Does Fivetran Remove Deleted Source Data From the Destination?

Question

I have deleted data from a source connector. Will Fivetran remove the deleted data from the connected target destination?

Environment

All destinations

Answer

When you delete data in the source, Fivetran soft-deletes it in the destination. In the destination table, we add an extra column named _fivetran_deleted and set its value to TRUE for the rows deleted in the source. We do not hard-delete data in the destination. See our documentation for more information.

To hard-delete data from entire tables in your destination, use a DELETE or DROP command. To hard-delete rows deleted from the source, write a post-load transformation to delete data where _fivetran_deleted = TRUE.