topic date column type in Data Engineering

date column type

arkiboys2 — Sun, 27 Oct 2024 18:26:37 GMT

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

Re: date column type

lbendlin — Sun, 27 Oct 2024 20:34:43 GMT

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

Re: date column type

arkiboys2 — Mon, 28 Oct 2024 05:47:18 GMT

does that help with the solution of my question?

thanks

Re: date column type

Anonymous — Mon, 28 Oct 2024 08:06:18 GMT

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!

Re: date column type

Anonymous — Fri, 01 Nov 2024 07:24:15 GMT

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