Change Data Type

Click on the three dots at your source and select Edit. Navigate to the Data Types tab to change your column names and data types.

In what cases do data types need to be changed?

Example 1:
You want to union tables A and B. In table A, the data type of column “amount” is integer. In table B, the same column’s data type is float. You will need to change the table A’s column data type to float.

Example 2:
Your destination is expecting column’s “ID” to be integer. However, extracted “ID” from source A is string. Change the data type to integer.

Changing Data Type Risks

If you decide to change your data types, keep the following in mind to ensure your source won’t malfunction.

You will need to change the data type in your data warehouse as well. The data types must match otherwise the data won’t be loaded correctly. In case your database does not allow changing data types, you will need to create a new table in your destination, or a new flow in Dataddo.

Although both are numerical data types, integer does not have decimal points. If you change from float to integer, your values will lose precision. For example, the value will change from 8.38 to 8.