Policy: GCP > BigQuery > Dataset > ServiceNow > Table > Definition

The policy enables the definition of ServiceNow table properties, including its name and the base table from which it extends, and details the specific columns required for representing GCP > BigQuery > Dataset data.

Targets

This policy targets the following resource types:

ServiceNow > Instance

Primary Policy

This policy is used with the following primary policy:

GCP > BigQuery > Dataset > ServiceNow > Table

Controls

Setting this policy configures this control:

GCP > BigQuery > Dataset > ServiceNow > Table

Policy Specification

Schema Type	`object`
Default	table: name: guardrails_gcp_bigquery_dataset label: GCP > BigQuery > Dataset extendsTable: cmdb_ci columns: - name: access label: Access type: string size: 1000 - name: creation_time label: Creation Time - name: dataset_id label: Dataset ID - name: dataset_location label: Location - name: dataset_name label: Name - name: default_partition_expiration_ms label: Default Partition Expiration Ms - name: default_table_expiration_ms label: Default Table Expiration Ms - name: description label: Description - name: etag label: Etag - name: id label: ID - name: is_case_insensitive label: Is Case Insensitive type: boolean - name: kind label: Kind - name: kms_key_name label: KMS Key Name - name: labels label: Labels type: string size: 1000 - name: last_modified_time label: Last Modified Time - name: max_time_travel_hours label: Max Time Travel Hours - name: project label: Project ID type: string - name: region label: Region Name type: string - name: self_link label: Self Link - name: tags label: Tags type: string size: 1000 - name: zone_name label: Zone Name type: string

Schema Type

object

Default

table:
  name: guardrails_gcp_bigquery_dataset
  label: GCP > BigQuery > Dataset
  extendsTable: cmdb_ci
columns:
  - name: access
    label: Access
    type: string
    size: 1000
  - name: creation_time
    label: Creation Time
  - name: dataset_id
    label: Dataset ID
  - name: dataset_location
    label: Location
  - name: dataset_name
    label: Name
  - name: default_partition_expiration_ms
    label: Default Partition Expiration Ms
  - name: default_table_expiration_ms
    label: Default Table Expiration Ms
  - name: description
    label: Description
  - name: etag
    label: Etag
  - name: id
    label: ID
  - name: is_case_insensitive
    label: Is Case Insensitive
    type: boolean
  - name: kind
    label: Kind
  - name: kms_key_name
    label: KMS Key Name
  - name: labels
    label: Labels
    type: string
    size: 1000
  - name: last_modified_time
    label: Last Modified Time
  - name: max_time_travel_hours
    label: Max Time Travel Hours
  - name: project
    label: Project ID
    type: string
  - name: region
    label: Region Name
    type: string
  - name: self_link
    label: Self Link
  - name: tags
    label: Tags
    type: string
    size: 1000
  - name: zone_name
    label: Zone Name
    type: string

In Your Workspace

Policy Settings by Type report

Developers

Category URI

tmod:@turbot/turbot#/control/categories/cloudIntegration

Policy Type URI

tmod:@turbot/servicenow-gcp-bigquery#/policy/types/datasetServiceNowTableDefinition

GraphQL

query policyType(id: "tmod:@turbot/servicenow-gcp-bigquery#/policy/types/datasetServiceNowTableDefinition") { … }

query policySettings(filter: "policyTypeId:'tmod:@turbot/servicenow-gcp-bigquery#/policy/types/datasetServiceNowTableDefinition'") { … }

query policyValues(filter: "policyTypeId:'tmod:@turbot/servicenow-gcp-bigquery#/policy/types/datasetServiceNowTableDefinition'") { … }

CLI

Get Policy Type

turbot graphql policy-type --id "tmod:@turbot/servicenow-gcp-bigquery#/policy/types/datasetServiceNowTableDefinition"

Get Policy Settings

turbot graphql policy-settings --filter "policyTypeId:tmod:@turbot/servicenow-gcp-bigquery#/policy/types/datasetServiceNowTableDefinition"