Hi All,
I have more number of SQLs as part of one transformation in celonis. I would like to include a info to be printed on the transformation log after it completes a particular statement for debugging/tracking purpose(same like SQL's print command).
Could you please help me with option for the same?
Thanks in Advance. :)
Rather than a print function, why not create an audit table that single rows of data are written to on completion like, table name, completion time, number of records, etc. If is only for debugging then this should be sufficient for recording. For tracking this will have a little overhead so may want to be careful.
Rather than a print function, why not create an audit table that single rows of data are written to on completion like, table name, completion time, number of records, etc. If is only for debugging then this should be sufficient for recording. For tracking this will have a little overhead so may want to be careful.
Hi Sunny,
I really appreciate for your response on my question. :)
I agree your point will work out. But we don't have that option for different reason. So we are expecting to display the message in Celonis transformation log itself.
+26Hi @nanthinidevi.p,
Interesting use case! Celonis uses Vertica SQL in the back-end, however not all functionalities are included. Vertica has some logging options, so my suggestion would be to see if that works. In the link below, you can find the documentation.
I'm curious if it works, good luck!
Kind regards,
Jan-peter
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
