Name	Name	Last commit message	Last commit date
parent directory ..
.gcloudignore	.gcloudignore
.gitignore	.gitignore
README.md	README.md
auth_util.py	auth_util.py
create_service_account.sh	create_service_account.sh
deploy_function.sh	deploy_function.sh
group_sync.py	group_sync.py
group_sync_test.py	group_sync_test.py
main.py	main.py
requirements.txt	requirements.txt
schedule_job.sh	schedule_job.sh

Name

Last commit message

Last commit date

BigQuery Group Sync For Row Level Access

Sample code to synchronize group membership from G Suite/Cloud Identity into BigQuery and join that with your data to control access at row level.

Source files

group_sync.py and group_sync_test.py: main code and unit tests.
auth_util.py: utility function to perform domain-wide delegation.
main.py: Cloud Functions entry point.
requirements.txt: Python dependencies.
create_service_account.sh: gcloud commands to create service account with the right permissions.
deploy_function.sh: gcloud command to deploy the Cloud Function.
schedule_job.sh: gcloud command to schedule periodic execution of the Cloud Function.

For much more background information and usage, please see this blog post.