Schema original file :

Environment segregation

  • Sandbox is the developer / data engineer local environment to run talend studio with RDS Sandbox and GCP Sandbox project
  • DEV is the remote engine either on AWS or GCP and should run with RDS DEV and GCP Dev project
  • UAT is the remote engine either on AWS or GCP and should run with RDS UAT and GCP UAT project 
  • PREPROD is the remote engine either on AWS or GCP and should run with RDS PREPROD and GCP PREPROD project 
  • PROD is the remote engine either on AWS or GCP and should run with RDS PROD and GCP PROD project 

Team segregation

  • Data engineering team has full control on Sandbox / DEV and UAT environments, meaning that admin rights on GCP and AWS Remote engines as well as on RDS databases.
  • Data OPS team has full control on PREPROD and PROD environment, It is the only team to manage GCP and AWS Remote engines as well as RDS Databases.
  • Cloud OPS team provide the GCP projects and administrate them with Data OPS consultation and validation


  • No labels