RandomMonthName
The RandomMonthName transformer is crafted to populate specified database columns with random month names. This transformer is especially useful for scenarios requiring the simulation of time-related data, such as user birth months or event months, without relying on specific date values.
Parameters¶
| 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 | - |
Description¶
The RandomMonthName transformer utilizes the faker library to generate the names of months at random. It can be applied to any textual column in a database to introduce variety and realism into data sets that require representations of months without the need for specific calendar dates.
Example: Populate random month names for the user_profiles table¶
This example demonstrates how to configure the RandomMonthName transformer to fill the birth_month column in the user_profiles table with random month names, adding a layer of diversity to user data without using actual birthdates.
- schema: "public"
name: "user_profiles"
transformers:
- name: "RandomMonthName"
params:
column: "birth_month"
keep_null: false
With this setup, the birth_month column will be updated with random month names, replacing any existing non-NULL values. If the keep_null parameter is set to true, then existing NULL values within the column will remain untouched.