The Chartio Data Pipeline uses SQLite. Here is a long list of core functions that can be used in the Pipeline.
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)