The release template is communicated to the Data Ops team before every move to prod, and contains the various steps required to push the project to the pre-production and production environments.

The latest release template is found in this folder :

Release Details

When: 12/12/2022

Responsables: Julien COUPE/Mourad GHISSASSI

Environment type: PROD/PRE-PROD

Version: 1.0.3

JIRA : https://solvayagile.atlassian.net/jira/software/c/projects/PA/boards/297

Target Environment

GCP	prj-carbon-footprint-prod	prj-carbon-footprint-pre-prod
Talend Server	ce-ew1-b-talend-gcp-remote-engine-prod	ce-ew1-b-talend-gcp-remote-engine-pre-prod
Talend Exploits	rds-ew1-tlnd-p-mssql-01	rds-ew1-tlnd-v-mssql-01

Requirements

Release Steps

Files and Folders

Cloud Storage

Create folders : Buckets already created in PRE-PROD and PROD
Add all manual files

BIGQUERY

Create the following dataset: CLC
Run the last query of following script : Create tables
Delete tables after good run

TMC

Project: Ind_PCF

Create the following Talend flows:

Type	Flow/Job	V.	Trigger - Cron
Task	F006_OrchFlow_PCF_Monthly_GCS	0.1.0	Every 6th of each month

Update the following Talend flows: version

Type	Flow/Job	V.	Trigger - Cron
Task	F004_PCF_Fill_DM_Area	0.1.9	Every 6th of each month
Task	F001_OrchFlow_PCF_Monthly	0.1.2	Every 6th of each month
Plan	PL_IND_PCF_monthly		Every 6th of each month

Delete the following Talend flows:

Type	Flow/Job

SQL Server - Parameters

Run the following scripts on SQL Server TALEND_EXPLOIT database:

SQL_Queries/SQL_context_Ind_PCF_[PROD/PRE-PROD].sql

After Release Verification

After First Run

Jobs Talend
Cloud Storage files
BigQuery (script)
Arborescence