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

The data destination gives error on schema type. any suggestions? thank you

not sure where the date/time in the 2nd screen-shot is coming from

 

 

 

 

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!

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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!

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    Fun fact:  a "date" column type does not exist.  Behind the scenes it is always datetime.  "Date"  is just a format.

  • 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!