Message from Fivetran Support

Unfortunately, at the moment we don't have an option to show if the field is of type dropdown or text in the destination. However, we seem to receive this information in the source.

Problem

Values of fields that are dropdown in ISSUE_FIELD_HISTORY need to be joined with  FIELD_OPTION to get the real value of the dropdown.

So this use case arises, lets say a custom field has the value 1024.

• It could be that its the ID for the table FIELD_OPTION and get the real value, lets say Android
• It could be that 1024 is the REAL value. 

Now you have a mix of values and you cant discern which one is dropdown and which one is the plain text.

Solution

As support said in the ticket, this information does exist in the source and would only need to be brought to Fivetran.