Forum Discussion

arkiboys2's avatar
arkiboys2
Helper IV
1 year ago
Solved

date column type

hello, the dataflow gen2 has several date columns. the datatype is set to date in the transformation the destination is the warehouse which has a table with some date columns as datatype: DATE Th...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi arkiboys2 ,

     

    Thanks for the reply from lbendlin .

     

    When dealing with data import, an error indicates a schema mismatch, make sure that the column types of the source and target tables match exactly, and check every step of the conversion in the data flow to make sure that the data types are consistent.

     

    You can set the data destination to an empty warehouse to see if the error occurs.

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!