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