The Chartio Data Pipeline uses SQLite. Please refer to the list of core functions that can be used in the Pipeline to learn more.
One of these functions is used to change a data type. To do this we can use an “Add Column” or “Edit Column” step in the pipeline and use a Custom formula. Using the CAST expression we can change the date type of a column.
The formula to use is
cast(“your_column_name” AS TYPE)
In my example, I wanted to change the type from an integer to real. I used
cast(“count of distinct tickets id” as real)
You can read more about the different data types.