lanre-og / gcp-project-ownership Goto Github PK

This repository will provide a method to get the project owner information(membership) for all the projects in a given GCP organization and save the information on a Bigquery table. This cript does the following:

• Defines schema and creates a Big query table to store ownership information.
• Retrieves project owner role members and save to bigquery table.

pip install --upgrade google-api-python-client google-auth-httplib2 google-auth-oauthlib

pip install --upgrade google-cloud-bigquery

pip install google-cloud-resource-manager

gcloud auth application-default login

python3 gcp-project-owner.py 

• Create table query result
• Insert row into BQ table.