How Does Fivetran Handle Records That Re-Populate After Being Hard-Deleted?

Question

How does Fivetran handle records that re-populate after being hard-deleted? Will that count towards paid usage?

Environment

Connector: PostgreSQL

Answer

When you hard-delete a record in PostgreSQL, we update the record's _fivetran_deleted column value to TRUE in your destination. When the record re-populates in PostgreSQL, we update the previously deleted record's _fivetran_deleted column value to FALSE.

If the record is deleted and re-populated in your source within the same calendar month, it will not count towards paid MAR.