The Convert columns data types allows to cast column data types.
Step parameters
Convert columns column(array)*: the columns to convert
To data typetype(string): the data type to convert into, either integer, float, text, date or boolean
Example
Input
Configuration
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.