How do I filter deleted Events from the Destination?

Last updated on May 30, 2023

Events deleted at Source have the value of the boolean column, __hevo__marked_deleted, set to True in the Destination. You can filter these Events by creating a Model using the __hevo__marked_deleted column. To do this, use the following query in your Model:

SELECT *
FROM table_name
WHERE __hevo__marked_deleted = false

where table_name is the Destination table containing all Source Events. For more information, read Creating a Model.

After you run the Model, the Destination table has only those Events that are existing in the Source table.

Note: This method works only for database Sources having Pipelines in Logical Replication mode. For non-database Sources and database Pipelines in other modes (Table and Custom SQL mode), you must manually delete the Events from the Destination table.


Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Nov-07-2022 NA Created as a new document.

Tell us what went wrong