GCP CIS v2.0.0 - Section 7 - BigQuery

This section addresses Google CloudPlatform BigQuery. BigQuery is a serverless, highly-scalable, and cost-effective cloud data warehouse with an in-memory BI Engine and machine learning built in.

This policy pack can help you automate the enforcement of GCP CIS benchmark section 7 best practices.

Review policy settings →

Getting Started

Requirements

Terraform
Guardrails mods:
- @turbot/gcp-bigquery

Credentials

To create a policy pack through Terraform:

Ensure you have Turbot/Admin permissions (or higher) in Guardrails
Create access keys in Guardrails

And then set your credentials:

export TURBOT_WORKSPACE=myworkspace.acme.com
export TURBOT_ACCESS_KEY=acce6ac5-access-key-here
export TURBOT_SECRET_KEY=a8af61ec-secret-key-here

Please see Turbot Guardrails Provider authentication for additional authentication methods.

Usage

Install Policy Pack

Note
By default, installed policy packs are not attached to any resources.

Policy packs must be attached to resources in order for their policy settings to take effect.

Clone:

git clone https://github.com/turbot/guardrails-samples.git
cd guardrails-samples/policy_packs/gcp/cis_v200/section7

Run the Terraform to create the policy pack in your workspace:

terraform init
terraform plan

Then apply the changes:

terraform apply

Apply Policy Pack

Log into your Guardrails workspace and attach the policy pack to a resource.

If this policy pack is attached to a Guardrails folder, its policies will be applied to all accounts and resources in that folder. The policy pack can also be attached to multiple resources.

For more information, please see Policy Packs.

Enable Enforcement

Tip
You can also update the policy settings in this policy pack directly in the Guardrails console.

Please note your Terraform state file will then become out of sync and the policy settings should then only be managed in the console.

By default, the policies are set to Check in the pack's policy settings. To enable automated enforcements, you can switch these policies settings by adding a comment to the Check setting and removing the comment from one of the listed enforcement options:

resource "turbot_policy_setting" "gcp_bigquery_dataset_publicly_accessible" {
  resource = turbot_policy_pack.main.id
  type     = "tmod:@turbot/gcp-bigquery#/policy/types/datasetPubliclyAccessible"
  note     = "GCP CIS v2.0.0 - Control: 7.1"
  # value    = "Check: Dataset is not publicly accessible"
  value    = "Enforce: Dataset is not publicly accessible"
}

resource "turbot_policy_setting" "gcp_bigquery_table_approved" {
  resource = turbot_policy_pack.main.id
  type     = "tmod:@turbot/gcp-bigquery#/policy/types/tableApproved"
  note     = "GCP CIS v2.0.0 - Control: 7.2"
  # value    = "Check: Approved"
  value    = "Enforce: Delete unapproved if new"
}

resource "turbot_policy_setting" "gcp_bigquery_dataset_encryption_at_rest" {
  resource = turbot_policy_pack.main.id
  type     = "tmod:@turbot/gcp-bigquery#/policy/types/datasetEncryptionAtRest"
  note     = "GCP CIS v2.0.0 - Control: 7.3"
  # value    = "Check: Customer managed key"
  # value    = "Check: Encryption at Rest > Customer Managed Key"
  # value    = "Enforce: Customer managed key"
  value    = "Enforce: Encryption at Rest > Customer Managed Key"
}

Then re-apply the changes:

terraform plan
terraform apply