Skip to main content
Question

Is it possible to use SQL Procedure in data transformations? If not, is it on the roadmap? Thanks!

  • August 6, 2021
  • 2 replies
  • 4 views

Is it possible to use SQL Procedure in data transformations? If not, is it on the roadmap? Thanks!

2 replies

janpeter.van.d
Level 12
Forum|alt.badge.img+26

Hi Zeynep,

 

In the data transformations Vertica SQL is used. While Vertica has procedure functionalities, the current configuration in Celonis (so called 'EON Mode') to scale nodes and resources doesn't support this. You can try to request this functionality by creating a ticket on this website, but since this would implies changes in the Vertica functionalities, I don't think it will be picked up.

 

Kind regards,

Jan-peter

 

vertica_ss1


Hi Zeynep,

 

In the data transformations Vertica SQL is used. While Vertica has procedure functionalities, the current configuration in Celonis (so called 'EON Mode') to scale nodes and resources doesn't support this. You can try to request this functionality by creating a ticket on this website, but since this would implies changes in the Vertica functionalities, I don't think it will be picked up.

 

Kind regards,

Jan-peter

 

vertica_ss1

Thank you so much for the detailed explanation! :) @janpeter.van.d