Skip to main content
Question

How to use data pool parameter?

  • March 20, 2025
  • 3 replies
  • 79 views
llllliz
Level 1
Forum|alt.badge.img

Dear community, 

I would like to set up a data pool parameter to allow me to switch between test and prod environment? 

So I would need two global variables for my data jobs:

  • var_data_source: to allow me switch between test schema and prod schema
  • var_table_name: to allow me when creating table to add _test at the end of the table name

I have only found the way to create parameters in EACH data job under transformation and refer to the data pool parameter. Is there a smarter way? 

I am still using the data integration (not OCPM). 

Thanks a lot! 

 

 

3 replies

carlos.taleg11
Level 9
Forum|alt.badge.img+10
  • carlos.taleg11
  • Level 9
  • 12 replies
  • September 16, 2025

Hi, I'm having the same problem. I can't find an example of how to use the datapool parameter. I think the documentation is pretty short on this point.

 

Carlos T.A.
janpeter.van.d
Level 12
Forum|alt.badge.img+26
  • janpeter.van.d
  • Level 12
  • 496 replies
  • September 17, 2025

Hi ​@llllliz, 

You’re doing it right. You can only refer to Data Pool Parameters within a Data Job by referring to them via a Data Job Parameter. 

 

mandree
Level 2
  • mandree
  • Level 2
  • 1 reply
  • October 27, 2025

Hi ​@llllliz, 

You’re doing it right. You can only refer to Data Pool Parameters within a Data Job by referring to them via a Data Job Parameter. 

 

That makes absolutly no sense. 😅
Would be nice, if Celonis makes that smarter. We don´t want to initialize the parameters in every single extraction / transformation. Initialization and declaration fpr GLOBAL parameters should be completly possible over the data pool parameter.


Community Code of ConductAccessibility statement