How to change a data type in the Pipeline

Data Pipeline

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.

Add an Edit Column step in the Pipeline with a Custom formula

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.

Related Data Pipeline Help Articles

See more