Revert Data Manager Publishing | Pricefx Knowledge Base

In Pricefx, the Data Manager publishing pipeline exposes refreshed Datamart data to queries by running a Publishing Data Load. As of version 16.0 (Black Cat), two additional capabilities are available: administrators can revert a completed publishing operation.

The 'refresh' data is treated as published until the first Publishing Data Load runs. Reverting publishing returns the Datamart to the state before the most recent Publishing Data Load was applied.

Revert Publishing

Overview

Reverting publishing undoes the most recent Publishing Data Load for a Datamart. After a revert, the Datamart reverts to the data state from the previous published version. This is useful when a publishing operation produces incorrect or incomplete data and must be rolled back without re-running a full refresh cycle.

By default, Datamart Table is columnar when Citus is installed before the last Data Load run.

How to Trigger a Revert

Add the following code into the Publish Data Load definition (Import & Export Definitions):

JSON

{
    "inputParams": [
      {
        "name": "revertPublishing",
        "type": "BOOLEANUSERENTRY",
        "value": true
      }
    ]
  }

Save changes.
Run the Publish Data Load.

After running the Publish Data Load, the Datamart is no longer published and queries use the Refresh tables again.

Result

Publishing is reversible, enabling testing, rollback, and flexibility.

Implementation Note

When rebuilding the Datamart Table, disruption is reduced by:

Not waiting for concurrent queries to finish before rebuilding.
Allowing new queries without waiting for the full Publish Data Load run.

A lock still occurs when replacing the rebuilt table at the end.