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

• Organization > folder > Project > Resources

GCP Project Overview: -

• Project Name:
• Project ID:
• Project Description:
• Project Owner
• Project purpose
• Project support teams (services scope)

GCP Resources/Services – Used in project:

• Eg: Compute Engine
• Big Query
• CloudSQL
• GCP Buckets/storage
• 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)

      2. Google groups newly created for this project:

• Data architects group name
• Data Engineers group name
• Data analyst/Business analyst Group name.
• View access group
• Others

Service Accounts created for this project: -

• ServiceAccountName – Description/Purpose – Application Name  – Owner

       Access rights/roles/granted for the service accounts.

GCP Buckets:   

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

Big query:

• Datasets
• Tables
• SQL Queries/views – Logic.
• Data flow

ProjectName:

prj-xxx-desc-dev

prj-xxx-desc-sit

prj-xxx-desc-ppd

prj-xxx-desc-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: