Convert columns data types

The Convert columns data types allows to cast column data types.

Step parameters

• Convert columns column(array)*: the columns to convert

• To data type type(string): the data type to convert into, either integer, float, text, date or boolean

Example

Input

Column header - convert input

Configuration

{
  "columns": ["id", "boolean_column"]
  "data_type": "text"
}

Output

Column header - convert output

In a effort to harmonize as much as possible the conversion behaviors, for some cases, in NativeSql our implementation casting works otherwise than the CAST AS method.

Precisely, when casting float to integer, the default behavior rounds the result, other languages truncate it. That’s why the use of TRUNCATE was implemented when converting float to int. The same implementation was done when converting strings to int (for date represented as string). As for the conversion of date to int, we handled it by assuming the dataset’s timestamp is in TIMESTAMP_NTZ format.