Organizations need a way to back out a bad load. Deleting entities that were newly added by the bad load is easy. Backing out features that got added to pre-existing entities is a bit more complicated.
The “Prune” feature was introduced to remove specific features that got added during a bad load. The implementation also supports a more general maintenance activity should one want to remove old features from existing entities e.g., expiring old values beyond a certain age.
The Prune method is implemented via a data source action with associated dates as follows:
The Prune action requires either a PRUNE_BEFORE or PRUNE_AFTER tag. However, both could be supplied if desired. Upon receiving a Prune message, the system will remove any features meeting the PRUNE_BEFORE or PRUNE_AFTER date based on features last update date (obs_feat_ekey.sys_lstupd_dt).
To back out a load, the user can either create the Prune documents from their own data sources or from G2’s log_obs_ent table using the date the record was loaded as the PRUNE_AFTER date.