Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

multiple environments

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

Matillion Agent  

Ian Funnell —

Hi Daniel,

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:

  1. Using Environment Variables (Project / Manage Environment Variables), and set different values for different Environments
  2. Using the Password Manager, and set different passwords in different Environments
  3. Make your jobs data-driven, using for example the Table Iterator

The manual job export & import (from Project / Export and / Import) is also a good way to do this.

Best regards,
Ian

Post Your Community Answer

To add an answer please login