date column type

[arkiboys2]

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

[Anonymous]

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!

[Anonymous · Accepted solution]

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!

[arkiboys2]

does that help with the solution of my question?

thanks

[lbendlin]

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