GoogleCloudPlatform / bigquery-utils

Useful scripts, udfs, views, and other utilities for migration and data warehouse operations in BigQuery.
https://cloud.google.com/bigquery/
Apache License 2.0
1.11k stars 277 forks source link

BigQuery CAI Scripts #394

Open timothymanuel opened 8 months ago

timothymanuel commented 8 months ago

The CAI Scripts help analyze the CAI export tables in BigQuery to understand mappings of roles or permissions to resources within GCP.

This first pull request has a couple of scripts to understand the IAM Principals that can access BigQuery tables in the Organization. This script will enable Data Stewards / Platform Owners understand who has access to what table in BigQuery.