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...
Data Engineering
  • 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!

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi arkiboys2 ,

 

Is my follow-up just to ask if the problem has been solved?

 

If so, can you accept the correct answer as a solution or share your solution to help other members find it faster?

 

Thank you very much for your cooperation!

 

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!