Resource Type: GCP > BigQuery > Dataset

Resource Context

Dataset is a part of the BigQuery service.

Each Dataset lives under a Project.

Controls

The primary controls for GCP > BigQuery > Dataset are:

• Active
• Approved
• CMDB
• Discovery
• Encryption at Rest
• Labels
• Publicly Accessible
• ServiceNow
• Usage

It is also targeted by these controls:

• GCP > BigQuery > Table > Discovery
• GCP > CIS v2.0 > 7 - BigQuery > 7.01 - Ensure That BigQuery Datasets Are Not Anonymously or Publicly Accessible
• GCP > CIS v2.0 > 7 - BigQuery > 7.03 - Ensure That a Default Customer-Managed Encryption Key (CMEK) Is Specified for All BigQuery Data Sets

Category

• Analytics

In Your Workspace

• Controls by Resource Type report
• Policy Settings by Resource Type report
• Resources by Resource Type report

Developers

Resource Type URI

tmod:@turbot/gcp-bigquery#/resource/types/dataset

Category URI

tmod:@turbot/turbot#/resource/categories/analytics

GraphQL

query resource(id: "tmod:@turbot/gcp-bigquery#/resource/types/dataset") { … }

query resourceActivities(filter: "resourceId:'tmod:@turbot/gcp-bigquery#/resource/types/dataset'") { … }

mutation createResource(input: { … })

mutation updateResource(input: { … })

CLI

Get Resource

turbot graphql resource --id "tmod:@turbot/gcp-bigquery#/resource/types/dataset"

Steampipe Query

Get Resource

select * from guardrails_resource where resource_type_uri = 'tmod:@turbot/gcp-bigquery#/resource/types/dataset';

Get Policy Settings (By Resource ID)

select * from guardrails_policy_setting where filter = 'resourceTypeId:"tmod:@turbot/gcp-bigquery#/resource/types/dataset"';

Get Resource Notification

select * from guardrails_notification where resource_type_uri = 'tmod:@turbot/gcp-bigquery#/resource/types/dataset' and notification_type in ('resource_updated', 'resource_created');