InputTable Schema
| Column | Data Type | Description |
|---|---|---|
| input_column | VARCHAR (CHARACTER SET LATIN or UNICODE) or NUMERIC | Column whose name can appear as TargetColumn in TransformationTable. |
TransformationTable Schema
| Column | Data Type | Description |
|---|---|---|
| TargetColumn | VARCHAR (CHARACTER SET LATIN or UNICODE) |
Name of InputTable column to transform. |
| Transformation | VARCHAR (CHARACTER SET LATIN or UNICODE) |
Transformation to apply to TargetColumn—for allowed transformations, see following table. |
| Parameters | VARCHAR (CHARACTER SET LATIN or UNICODE) |
[Optional] Transformation parameters in JSON format. If this column is absent and transformation has parameter, function uses default value in Parameters column of following table. |
| DefaultValue | NUMERIC | [Optional] Default value for transformed value if TargetColumn is nonnumeric or NULL. If this column is absent, function uses default value 0. |
| Transformation | Parameter | Operation on TargetColumn Value x |
|---|---|---|
| ABS | None | |x| |
| CEIL | None | CEIL (x) (Least integer ≥ x) |
| EXP | None | e
x
(e = 2.718) |
| FLOOR | None | FLOOR (x) (Greatest integer ≤ x) |
| LOG | [Optional] {"base": base} Default: e |
LOG base (x) |
| POW | [Optional] {"exponent": exponent} Default: 1 |
x exponent |
| SIGMOID | None | 1 / (1 + e-x ) |
| TANH | None | (e x - e-x ) / (e x + e-x ) |