Issue
Can I change the data-type of the column in the destination?
Environment
Destinations
Resolution
It is not recommended that you change the data type in the destination.
Fivetran chooses the data types and uses the most appropriate with respect to the source data type. Our Documentation talks about the supported data types for each destination.
If you change the data type of a column to something which was not chosen by the connector, you may encounter data integrity issues or a broken connector.
Cause
Each destination supports different data types.