Skip to content


The RandomName transformer is designed to populate specified database columns with random full names, including both first names and last names. This tool is indispensable for applications requiring the simulation of user profiles, testing user registration systems, or anonymizing user data in datasets.


Name Description Default Required Supported DB types
column The name of the column to be affected Yes text, varchar
keep_null Indicates whether NULL values should be preserved false No -


The RandomName transformer utilizes a comprehensive list of first names and last names to inject random full names into the designated database column. This feature allows for the creation of diverse and realistic user profiles by simulating a variety of full names without using real user data.

Example: Populate random full names for the user_profiles table

This example demonstrates configuring the RandomName transformer to populate the name column in the user_profiles table with random full names. It is an effective method for simulating a variety of user profiles with diverse full names.

RandomName transformer example
- schema: "public"
  name: "user_profiles"
    - name: "RandomName"
        column: "name"
        keep_null: false

In this configuration, the name column will be updated with random full names for each user profile entry, replacing any existing non-NULL values. If the keep_null parameter is set to true, existing NULL values in the column will be preserved, ensuring the integrity of records where full name information is not applicable or provided.