RandomBool

Generate random boolean values.

Parameters

Name	Description	Default	Required	Supported DB types
column	The name of the column to be affected		Yes	bool
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 RandomBool transformer generates a random boolean value. 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 boolean for a column

In the following example, the RandomBool transformer generates a random boolean value for the salariedflag column.

RandomBool transformer example

- schema: "humanresources"
  name: "employee"
  transformers:
    - name: "RandomBool"
      params:
        column: "salariedflag"

Result

Column	OriginalValue	TransformedValue
salariedflag	t	f