Reference case #197836

Fivetran is converting ARRAY column in source to VARCHAR column in target.  Both source and target systems are snowflake here so ideally everyone would expect a data type in same source system to remain same in the same target system which is snowflake here.
Fivetran should not change the data type in between as it's a very bad experience for the end users. 

Please let me know if you need more details.