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-complianceStart the Powerpipe server:
steampipe service startpowerpipe serverOpen http://localhost:9033 in your browser and select BigQuery.
Run this benchmark in your terminal:
powerpipe benchmark run gcp_compliance.benchmark.all_controls_bigquerySnapshot and share results via Turbot Pipes:
powerpipe benchmark run gcp_compliance.benchmark.all_controls_bigquery --shareControls
- 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