Can I Change a Column's Data type?

Question

How does Fivetran determine each column's data type? Can I set a data type for each column synced to my destination?

Environment

Connector: Anaplan

Answer

We use Anaplan's API to retrieve each export's metadata, which includes the data types. These data types determine the data types for the columns in your destination. See Anaplan's Get export definition documentation for more information.

To sync a different data type to your destination, you must change the applicable line item's data type in Anaplan.