Why Is My Custom Field Syncing as ARRAY Instead of VARCHAR?

Question

Why is a custom field column syncing as ARRAY instead of VARCHAR? How can I address this?

Environment

Connector: Asana

Answer

Fivetran determines the destination data type based on the data returned by the Asana API. If a custom field column syncs as ARRAY, Asana is returning the field as a multi-value field. This may happen for custom fields that support multiple selections or multiple assigned users.

To use this data as VARCHAR, transform the column in your destination using your preferred data transformation tool.