We are building a data warehouse and use EasyMorph to populate it. We have created separate small data flows, 1 for each reference table in the datawarehouse (1 file per flow so that we can run the flow individually on the server).
We have 1 Main flow (separate easymorph file) that lists all morph files and executes them using an iteration.
In the separate flows, we have parameters like “database_connector_staging”, “S3_bucket”, etc.
Is there a quick way to change all parameter values in all subflows (= the separate files) easily?
I know that when we execute the iteration, the parameters in the separate files are overwritten, so when we we move from dev to test to production, we simply have to run our main flow and set the parameter values to these of the environment we are using to load all reference tables.
However, if we want to change all parameter values in all individual flows (for testing reasons in different environments), we would have to set them manually.
Therfore my question, is there a quick way to do a find replace of parameter values in the subflows ?
This would save me a lot of time
Other question: For this use case, it would be easy if we could put all subflows in a separate module in 1 easymorph file (which is possible). For example: all reference tables that have to be loaded in the staging layer of the datawarehouse.
This option however, does not allow for running a separate module on the server ? We really have to be able to populate 1 reference table for instance e.g. in case of errors or updates.
Therefore also my earlier question about disabeling all actions in modules in 1 single click.