We currently have two instances of Matillion running: one in a staging environment and one in a production environment. The setup should be identical except configuration such as database connections and S3 buckets. We would like to do our work on the staging instance and automate the deployment to production without having to copy over all the components from staging. Our current idea is to use the API to export the staging data, convert everything staging-specific to be production-specific, and upload to production overriding what's currently there.
Is there a simpler way to do this, preferably through Matillion?
1 Community Answers
Ian Funnell —
We (Matillion) use the API ourselves to migrate code from Development into Production.
You won’t need to change any logic if you parameterize all the environment-specific settings. Matillion has several ways to do this:
Using Environment Variables (Project / Manage Environment Variables), and set different values for different Environments
Using the Password Manager, and set different passwords in different Environments