timestamp issue when read from mysql then write to snowflake

I am getting a database error when trying to write to a snowflake table: expecting timestamp_ntz(9) but got timestamp_ltz((9) for all the date fields that come out of mysql database, has anyone experienced the same issue and how did you solve it? Thanks!