According to the PostgreSQL and MySQL connector docs, ENUMs are supported by Fivetran. There isn't currently any information on this page that indicates how these fields are mapped before they land into Snowflake since ENUM columns are not supported in Snowflake.