Custom database types
To support custom database types:
-
Use the output database with already created schema and its child objects, see the
DO_NOT_CREATE
in YAML configuration for more details. -
Explicitly define the generator for a custom type column in the configuration file.
For example, for the following custom ENUM type:
CREATE TYPE public.transaction_type_t AS ENUM ('SENT', 'RECEIVED');
Use a configuration like this:
transformations:
- columns:
- "transaction_type"
params:
type: "categorical_generator"
categories:
values:
- "SENT"
- "RECEIVED"
probabilities:
- 0.6
- 0.4