Skip to main content

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! 

 

 

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.

 


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.