Skip to main content
On each run, Prophecy removes all existing rows from the target table and writes the incoming dataset. The target table always reflects the latest state of the source data.

​
Example: Replace product list

A product catalog is refreshed each day by replacing the existing table with the latest product list.
Existing target tableIncoming data setResulting target tableBecause this write mode replaces the entire table, any rows that are not present in the incoming dataset are removed. Prophecy does not compare existing and incoming rows or merge individual records. In this example, products 102 and 103 are removed because they are not included in the latest product list.

​
Partition the target table (BigQuery only)

The following partitioning parameters are available for the Wipe and Replace Table write mode on BigQuery.
Only BigQuery tables can be partitioned at the table level. To learn more about partitioning, jump to Partitioning.