How to separate test and production?
What's the best, or at least a good, practice for separating development/test setups from production? We're using one Matillion instance.
1) make a locked version 'Production' of the project, and do further development and testing in the default version
2) separate environments 'production' and 'test' that use different default schemas. All development, test and temporary views go to a temp schema, and only productive target tables to the production schema that will be backed up
3) create separate projects 'test' and 'production'
We've done 1) and 2). To do 3), we'd like to copy the tested version of processes from test to production. However, when we do Export & Import, we'll just get duplicate processes into the same, existing project. Is there a way to import as a new project?