Enforce GCP BigQuery Datasets Are Not Publicly Accessible

Enforcing GCP BigQuery datasets to not be publicly accessible is crucial to protect sensitive and proprietary data from unauthorized access and potential breaches. By restricting public access, organizations can maintain data privacy, comply with regulatory requirements, and safeguard against malicious activities.

This policy pack can help you configure the following settings for BigQuery datasets:

Enforce public access is disabled

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/bigquery/enforce_datasets_are_not_publicly_accessible

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"
  # value    = "Check: Dataset is not publicly accessible"
  value    = "Enforce: Dataset is not publicly accessible"
}

Then re-apply the changes:

terraform plan
terraform apply