Options
timestamp issue when read from mysql then write to snowflake
User118722
Member Posts: 3 Contributor I
in Help
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!
1
Best Answer
-
OptionsMPB_ Member Posts: 45 GuruHey ,have you tried to add a convert function into your SELECT query?
5