The following generators populate a column with a specific value or a random value of a specific type.
For more information about each generator and how to configure in the application, go to Data type and specific values.
Populates the field with an array of values.
The Blank generator inserts a null value.
Inserts a random boolean value - either true or false.
Inserts the same value into all of the rows.
Produces a JPEG image in binary format.
Populates the column with filler text.
Populates the column with a MongoDB object identifier.
Intended for document identifier columns in a MongoDB database.
Inserts a numeric value.
Populates the field with a JSON object.
Generates a random universally unique identifier (UUID).
{
"name": string,
"generator": "Array",
// Generator-specific fields
"items": {
"generator": string // Generator for the array values
// Configuration for the selected generator.
},
"distribution": "fixed"|"normal"|"uniform", // Distribution to use for the
// number of array values
// Fixed distribution
"exact_value": number // Exact number of array values
// Uniform distribution
"min": number, // Minimum number of array values
"max": number, // Maximum number of array values
// Normal distribution
"min": number, // Minimum number of array valuesl
"max": number, // Maximum number of array values
"mean": number, // Mean number of array values
"stddev": number, // Standard deviation for the number of array values
//End generator-specific fields
"percent_null": integer,
"virtual": boolean,
// Advanced options
"primary_key": boolean,
"index": boolean,
"seed": string,
"postprocessing_sql": string
}{
"name": string,
"data_type": string,
"generator": "Blank",
"virtual": boolean,
// Advanced options
"primary_key": boolean,
"index": boolean,
"seed": string,
"postprocessing_sql": string
}{
"name": string,
"data_type": string,
"generator": "Boolean",
"percent_null": integer,
"virtual": boolean,
// Advanced options
"primary_key": boolean,
"index": boolean,
"seed": string,
"postprocessing_sql": string
}{
"name": string,
"data_type": string,
"generator": "Constant",
// Generator-specific fields
"constant_value": string, // The value to assign to the column
// End generator-specific fields
"percent_null": integer,
"virtual": boolean,
// Advanced options
"primary_key": boolean,
"index": boolean,
"seed": string,
"postprocessing_sql": string
}{
"name": string,
"data_type": string,
"generator": "Image (binary)",
"percent_null": integer,
"virtual": boolean,
// Advanced options
"primary_key": boolean,
"index": boolean,
"seed": string,
"postprocessing_sql": string
}{
"name": string,
"data_type": string,
"generator": "Lorem Ipsum",
// Generator-specific fields
"lorem_ipsum_unit": "words"|"sentences"|"paragraphs", // Content format
"distribution": "fixed"|"normal"|"uniform", // Type of distribution to use
// -----------------------------------------------------------------------
// Fixed distribution
"exact_value": integer, // The exact length
// ----------------------------------------------------------------------
// Uniform distribution
"min": integer, // Minimum length
"max": integer, // Maximum length
// ---------------------------------------------------------------------
// Normal distribution
"min": integer, // Minimum length
"mean": string, // Mean length
"std_dev": string, // Standard deviation
"max": integer, // Maximum length
// End generator-specific fields
"percent_null": integer,
"virtual": boolean,
// Advanced options
"primary_key": boolean,
"index": boolean,
"seed": string,
"postprocessing_sql": string
}{
"name": string,
"data_type": string,
"generator": "Mongo ObjectId",
"percent_null": integer,
"virtual": boolean,
// Advanced options
"primary_key": boolean,
"index": boolean,
"seed": string,
"postprocessing_sql": string
}{
"name": string,
"data_type": string,
"generator": "Number",
// Generator-specific fields
"distribution": "autoincrement"|"uniform"|"binomial"|"exponential"|
"geometric"|"normal"|"poisson"|"series", // Distribution type
"min": integer // For autoincrement, the increment value
"variants": [ // Set of variants for non-autoincrement distribution
{
"condition_type": "sql"|”percentage", // The type of condition
"conditions": string, // For sql, the expression to identify the condition
// that triggers the variant
"condition_percentage": float, // For percentage, the percentage of records
// that use the variant
// ---------------------------------------------------------------------
// Uniform distribution
"min": integer, // Minimum value
"max": integer, // Maximum value
"decimals": integer, // Number of decimal places
// ---------------------------------------------------------------------
// Binomial distribution
"trials": string // Number of tests
"success_probability": string, // Success probability
// ---------------------------------------------------------------------
// Exponential distribution
"min": integer, // Minimum value
"rate": string, // Rate of increase
"max": integer, // Maximum value
"decimals": integer, // Number of decimal places
// ----------------------------------------------------------------------
// Geometric distribution
"min": integer, // Minimum value
"success_probability": string, // Success probability
"max": integer, // Maximum value
"decimals": integer, // Number of decimal places
// ---------------------------------------------------------------------
// Normal distribution
"min": integer, // Minimum value
"mean": string, // Mean value
"std_dev": string, // Standard deviation
"max": integer, // Maximum value
"decimals": integer, // Number of decimal places
// ---------------------------------------------------------------------
// Poisson distribution
"min": integer, // Minimum value
"mean": string, // Mean value
"max": integer, // Maximum value
"decimals": integer, // Number of decimal places
// ---------------------------------------------------------------------
// Series distribution
"start_field_id": uuid, // Start field
"end_field_id": uuid, // End field
"partition_by_field_id": uuid, // Partition by field
"order_by_field_id": uuid, // Order by field
"decimals": integer, // Number of decimal places
"curve_type": "exponential"|"logarithmic"|"from column", // Curve type
"rate": string, // Rate of increase for exponential and
// logarithmic curve types
"curve_type_field_id": uuid, // Field for From field curve type
"volatility_type": "fixed"|"from_column", // Type of volatility
"volatility": string, // Fixed volatility value
"volatility_field_id": uuid // From column volatility column
}
],
// End generator-specific fields
"percent_null": integer,
"virtual": boolean,
// Advanced options
"primary_key": boolean,
"index": boolean,
"seed": string,
"postprocessing_sql": string
}{
"name": string,
"generator": "Object",
// Generator-specific fields
"fields": [
// Entry for each field
{
"name": string // Name of the object field
"generator": string // Generator for the field value
// Configuration for the selected generator
}
],
// End generator-specific fields
"percent_null": integer,
"virtual": boolean,
// Advanced options
"primary_key": boolean,
"index": boolean,
"seed": string,
"postprocessing_sql": string
}{
"name": string,
"data_type": string,
"generator": "UUID",
"percent_null": integer,
"virtual": boolean,
// Advanced options
"primary_key": boolean,
"index": boolean,
"seed": string,
"postprocessing_sql": string
}