Change Data Type
  • 1 Minute to read
  • Dark

Change Data Type

  • Dark

Article Summary


Changing the data types in your source is not recommended. Proceed at your own risk.

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.
Data Sources - change data type

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.

1 - Your source is already in a flow to a data warehouse.

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.

2 - You want to change your data type from float to integer.

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.

Was this article helpful?

What's Next