We have Dev, Test and Prod EDW databases where we are utilizing default Environments to drive where the target data is landed. However, we also use an "ETL" database for interim tables that have their own Dev, Test and Prod. Whenever jobs are moved the ETL database components have to be manually changed. I am looking for the best way to utilize variables to make this process more automated, given the fact that you can only have one "default" environment at a time.
Hello!
You can use a python component with the context.updateVariable("variable", "new value") command at the beginning of your orchestration to set up the environment variables that you want to use.
More documentation on this here:
https://documentation.matillion.com/docs/2943424
Hope this answers your question?