Page tree



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: