Benchmark: BigQuery
Description
This section contains recommendations for configuring BigQuery resources.
Usage
Install the mod:
mkdir dashboardscd dashboardspowerpipe mod initpowerpipe mod install github.com/turbot/steampipe-mod-gcp-compliance
Start the Powerpipe server:
steampipe service startpowerpipe server
Open http://localhost:9033 in your browser and select BigQuery.
Run this benchmark in your terminal:
powerpipe benchmark run gcp_compliance.benchmark.all_controls_bigquery
Snapshot and share results via Turbot Pipes:
powerpipe benchmark run gcp_compliance.benchmark.all_controls_bigquery --share
Controls
- Ensure that a default customer-managed encryption key (CMEK) is specified for all BigQuery Data Sets
- Ensure that all BigQuery Tables are encrypted with Customer-managed encryption key (CMEK)
- Check if BigQuery datasets are publicly readable
- Enforce corporate domain by banning gmail.com addresses access to BigQuery datasets
- Enforce corporate domain by banning googlegroups.com addresses access to BigQuery datasets