GCP - Operational Dashboard

Project Hierarchy in GCP (Org/Folder/Project Name):

• Organization > folder > Project > Resources

GCP Project Overview: -

• Project Name: Operation Dashboard
• Project ID: prj-data-industrial-dash-dev / prj-data-industrial-dash-test / prj-data-industrial-dash-ppd / prj-data-industrial-dash-prod
• Project Description: KPIs related to industrial dashboard
• Project Owner : guillaume.gandemer@solvay.com / francois.carette@solvay.com
• Project purpose
• Project support teams (services scope)

GCP Resources/Services – Used in project:

• Eg: Compute Engine : NA 
• Big Query : Yes 
• CloudSQL : NA
• GCP Buckets/storage : Yes
• Cloud functions etc.

Google Groups: -

1. Google Groups having access to this project:

• Data architects group name :  
• Data Engineers group name : 
• Data analyst/Business analyst Group name. : 
• Other groups if any (EX. Data Developer group name)

>> By default when project got provisioned there are default groups automatically came in the project , for the default list please contact with Cloud ops team

      2. Google groups newly created for this project:

Service Accounts created for this project: -

• ServiceAccountName – Description/Purpose – Application Name  – Owner

       Access rights/roles/granted for the service accounts.

please find the all the requested information here 

GCP Buckets:   

• Bucket name, Folder, Objects – Path etc.
• Retention period
• Access policies

Big query:

• Datasets:  STG, ODS, WDL, DPL, DM , DataOcean , ODS_DataOcean,
• Tables : link
• SQL Queries/views – Logic.
• Data flow

ProjectName:

prj-data-industrial-dash-dev

prj-data-industrial-dash-test 

 prj-data-industrial-dash-ppd 

 prj-data-industrial-dash-prod

prj-xxx-desc-prod:

STG Schemas:

STG Schemas1:

STG Schema2:

STG Schema3:

Tablelist:

Data Ocean Schemas:

DS_xxx_yyy1 

DS_xxx_yyy2 

DS_xxx_yyy3

Reporting Schemas: