How to change a data type in the pipeline

Data Pipeline

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.

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 here and here.

Related Data Pipeline Help Articles

See more