How do you convert date column from string to datetime at the extraction stage? I tried configuring the column but keep receiving an error.

Hello @william.ross12 , do you still have issue? May I have your sample input? Celonis is based on SQL Reference (vertica.com)

TO_TIMESTAMP is probably the function you need.

https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Functions/Formatting/TO_TIMESTAMP.htm?tocpath=SQL%20Reference%20Manual%7CSQL%20Functions%7CFormatting%20Functions%7C_____5

Example

TO_TIMESTAMP(_CELONIS_CHANGE_DATE,'YYYY-MM-DD HH:MI:SS.MS')

Just small note, Celonis uses 10.1.0 Vertica version, but in most function there's no difference.

Would go the same direction on extracting string, and then creating table with real timestamp using that function. @Guillermo Gost post may be marked as best.

Best Regards,

Mateusz Dudek

Thank you that's really helpful! Apologies for late reply