Our goal is to sync between Oracle and Snowflake with CDC Oracle.
Some of our source tables in Oracle are defined as DATE. So we created this tables also in Snowflake with the same type, DATE.
But now I get this error message:
But in this case the field ACTIVITY_TIME is DATE on Oracle and Snowflake.
Later I noticed that we don’t have any problem if I convert all DATE fields into DATETIME attributes on Snowflake. But looking in the documentation, there is nothing mentioned that we have to use DATETIME in such cases. The type DATE is explicitly mentioned as supported type.
Does anyone had the same issues? I mean it’s not so unusual to use the DATE type in a database