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