Skip to content


Replace an original value by the provided one.


Name Description Default Required Supported DB types
column The name of the column to be affected Yes any
replace The value to replace Yes -
keep_null Indicates whether NULL values should be replaced with transformed values or not true No -
validate Performs a decoding procedure via the PostgreSQL driver using the column type to ensure that values have correct type true No -


The Replace transformer replace an original value from the specified column with the provided one. It can optionally run a validation check with the validate parameter to ensure that the values are of a correct type before starting transformation. The behaviour for NULL values can be configured using the keep_null parameter.

Example: Updating the jobtitle column

In the following example, the provided value: "programmer" is first validated through driver decoding. If the current value of the jobtitle column is not NULL, it will be replaced with programmer. If the current value is NULL, it will remain NULL.

Replace transformer example
- schema: "humanresources"
  name: "employee"
  - name: "Replace"
      column: "jobtitle"
      value: "programmer"
      keep_null: false
      validate: true
Expected result
| column name | original value          | transformed |
| jobtitle    | Chief Executive Officer | programmer  |