Data type and specific values

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.

Array

The Array generator is a premium feature. Free plan users have limited access to premium features.

Populates the field with an array of values.

{
   "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
}

Blank

The Blank generator inserts a null value.

{ 
  "name": string,
  "data_type": string,
  "generator": "Blank",
  "virtual": boolean,
  // Advanced options
  "primary_key": boolean,
  "index": boolean,
  "seed": string,
  "postprocessing_sql": string
}

Boolean

Inserts a random boolean value - either true or false.

{ 
  "name": string,
  "data_type": string,
  "generator": "Boolean",
  "percent_null": integer,
  "virtual": boolean,
  // Advanced options
  "primary_key": boolean,
  "index": boolean,
  "seed": string,
  "postprocessing_sql": string
}

Constant

Inserts the same value into all of the rows.

{ 
  "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
}

Image (binary)

Produces a JPEG image in binary format.

{ 
  "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
}

Lorem Ipsum

Populates the column with filler text.

{ 
  "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
}

Mongo ObjectId

Populates the column with a MongoDB object identifier.

Intended for document identifier columns in a MongoDB database.

{ 
  "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
}

Number

Variants are a premium feature. Free plan users have limited access to premium features.

Inserts a numeric value.

{ 
  "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
}

Object

The Object generator is a premium feature. Free plan users have limited access to premium features.

Populates the field with a JSON object.

{
   "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
}

UUID

Generates a random universally unique identifier (UUID).

{ 
  "name": string,
  "data_type": string,
  "generator": "UUID",
  "percent_null": integer,
  "virtual": boolean,
  // Advanced options
  "primary_key": boolean,
  "index": boolean,
  "seed": string,
  "postprocessing_sql": string
}