random_string

Generate a random string using the provided characters within the specified length range.

Parameters

Name	Description	Default	Required	Supported DB types
column	The name of the column to be affected		Yes	text, varchar, char, bpchar, citext
min_length	The minimum length of the generated string		Yes	-
max_length	The maximum length of the generated string		Yes	-
symbols	The range of characters that can be used in the random string	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ	No	-
keep_null	Indicates whether NULL values should be replaced with transformed values or not	true	No	-
engine	The engine used for generating the values [random, hash]. Use hash for deterministic generation	random	No	-

Description

The RandomString transformer generates a random string with a length between min_length and max_length using the characters specified in the symbols string as the possible set of characters. The behaviour for NULL values can be configured using the keep_null parameter.

The engine parameter allows you to choose between random and hash engines for generating values. Read more about the engines in the Transformation engines section.

Example: Generate a random string for accountnumber

In the following example, a random string is generated for the accountnumber column with a length range from 9 to 12. The character set used for generation includes 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ.

RandomString transformer example

- schema: "purchasing"
  name: "vendor"
  transformers:
    - name: "RandomString"
      params:
        column: "accountnumber"
        min_length: 9
        max_length: 12
        symbols: "1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ"

Result

Column	OriginalValue	TransformedValue
accountnumber	AUSTRALI0001	4VUI6P2OZ