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 | ||
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:
After Release Verification
After First Run
- Jobs Talend
- Cloud Storage files
- BigQuery (script)
- Arborescence