Skip to content


Replace values randomly chosen from a provided list.


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


The RandomChoice transformer replaces one randomly chosen value from the list provided in the values parameter. You can use the validate parameter to ensure that values are correct before applying the transformation. The behaviour for NULL values can be configured using the keep_null parameter.

Example: Choosing randomly from provided dates

In this example, the provided values undergo validation through PostgreSQL driver decoding, and one value is randomly chosen from the list.

RandomChoice transformer example
    - schema: "humanresources"
      name: "jobcandidate"
        - name: "RandomChoice"
            column: "modifieddate"
            validate: true
              - "2023-12-21 07:41:06.891"
              - "2023-12-21 07:41:06.896"