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.

Hi @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.

Logging (vertica.com)

I'm curious if it works, good luck!

Kind regards,

Jan-peter