Skip to main content
Update records that match conditions defined in the Use Predicate parameter. Instead of updating individual rows, it replaces the entire partition of the table that matches the given predicate. The predicate defines which rows in the target table should be fully replaced with the incoming data.

​
Parameters

​
Example: Replace sales from January 5 onward

A sales table uses the predicate sale_date >= '2024-01-05'. When a corrected dataset arrives, Prophecy removes all rows that satisfy the predicate and replaces them with the incoming dataset. Rows that do not satisfy the predicate remain unchanged. Predicate: sale_date >= '2024-01-05'
Existing target tableIncoming datasetResulting target tableBecause this write mode replaces all rows that satisfy the predicate, Prophecy removes every existing row that matches the predicate before writing the incoming dataset. Rows that do not satisfy the predicate remain unchanged. In this example, the row for 2024-01-15 (ORDER_ID 203) is removed because it matches the predicate but is not included in the incoming dataset, while the row from 2023-12-20 remains unchanged.