Hevo automatically promotes the data type of the Destination table column to accommodate Source data of different data types for tables smaller than 50GB.
Read Handling Different Data Types in Source Data.