Resource Type: GCP > BigQuery > Table

Resource Context

Table is a part of the BigQuery service.

Each Table lives under a Dataset.

Controls

The primary controls for GCP > BigQuery > Table are:

• Active
• Approved
• CMDB
• Discovery
• Labels
• Policy
• ServiceNow
• Usage

It is also targeted by these controls:

• GCP > CIS v2.0 > 7 - BigQuery > 7.02 - Ensure That All BigQuery Tables Are Encrypted With Customer-Managed Encryption Key (CMEK)

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/table

Category URI

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

GraphQL

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

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

mutation createResource(input: { … })

mutation updateResource(input: { … })

CLI

Get Resource

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

Steampipe Query

Get Resource

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

Get Policy Settings (By Resource ID)

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

Get Resource Notification

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