Policy: Azure > Synapse Analytics > Workspace > 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 Azure > Synapse Analytics > Workspace data.

Targets

This policy targets the following resource types:

ServiceNow > Instance

Primary Policy

This policy is used with the following primary policy:

Azure > Synapse Analytics > Workspace > ServiceNow > Table

Controls

Setting this policy configures this control:

Azure > Synapse Analytics > Workspace > ServiceNow > Table

Policy Specification

Schema Type	`object`
Default	table: name: guardrails_azure_synapseanalytics_synapseworkspace label: Azure > Synapse Analytics > Workspace extendsTable: cmdb_ci columns: - name: adla_resource_id label: Adla Resource ID - name: connectivity_endpoints label: Connectivity Endpoints type: string size: 1000 - name: default_data_lake_storage label: Default Data Lake Storage type: string size: 1000 - name: encryption label: Encryption type: string size: 1000 - name: extra_properties label: Extra Properties type: string size: 1000 - name: id label: ID - name: identity label: Identity type: string size: 1000 - name: managed_resource_group_name label: Managed Resource Group Name - name: managed_virtual_network label: Managed Virtual Network - name: managed_virtual_network_settings label: Managed Virtual Network Settings type: string size: 1000 - name: private_endpoint_connections label: Private Endpoint Connections type: string size: 1000 - name: provisioning_state label: Provisioning State - name: public_network_access label: Public Network Access - name: purview_configuration label: Purview Configuration type: string size: 1000 - name: region label: Region - name: region_name label: Region Name type: string size: 200 - name: resource_group label: Resource Group type: string - name: sql_administrator_login label: SQL Administrator Login - name: sql_administrator_login_password label: SQL Administrator Login Password - name: subscription_id label: Subscription ID type: string - name: synapse_workspace_name label: Name - name: tags label: Tags type: string size: 1000 - name: type label: Type - name: virtual_network_profile label: Virtual Network Profile type: string size: 1000 - name: workspace_repository_configuration label: Workspace Repository Configuration type: string size: 1000 - name: workspace_uid label: Workspace UID type: string size: 1000

Schema Type

object

Default

table:
  name: guardrails_azure_synapseanalytics_synapseworkspace
  label: Azure > Synapse Analytics > Workspace
  extendsTable: cmdb_ci
columns:
  - name: adla_resource_id
    label: Adla Resource ID
  - name: connectivity_endpoints
    label: Connectivity Endpoints
    type: string
    size: 1000
  - name: default_data_lake_storage
    label: Default Data Lake Storage
    type: string
    size: 1000
  - name: encryption
    label: Encryption
    type: string
    size: 1000
  - name: extra_properties
    label: Extra Properties
    type: string
    size: 1000
  - name: id
    label: ID
  - name: identity
    label: Identity
    type: string
    size: 1000
  - name: managed_resource_group_name
    label: Managed Resource Group Name
  - name: managed_virtual_network
    label: Managed Virtual Network
  - name: managed_virtual_network_settings
    label: Managed Virtual Network Settings
    type: string
    size: 1000
  - name: private_endpoint_connections
    label: Private Endpoint Connections
    type: string
    size: 1000
  - name: provisioning_state
    label: Provisioning State
  - name: public_network_access
    label: Public Network Access
  - name: purview_configuration
    label: Purview Configuration
    type: string
    size: 1000
  - name: region
    label: Region
  - name: region_name
    label: Region Name
    type: string
    size: 200
  - name: resource_group
    label: Resource Group
    type: string
  - name: sql_administrator_login
    label: SQL Administrator Login
  - name: sql_administrator_login_password
    label: SQL Administrator Login Password
  - name: subscription_id
    label: Subscription ID
    type: string
  - name: synapse_workspace_name
    label: Name
  - name: tags
    label: Tags
    type: string
    size: 1000
  - name: type
    label: Type
  - name: virtual_network_profile
    label: Virtual Network Profile
    type: string
    size: 1000
  - name: workspace_repository_configuration
    label: Workspace Repository Configuration
    type: string
    size: 1000
  - name: workspace_uid
    label: Workspace UID
    type: string
    size: 1000

In Your Workspace

Policy Settings by Type report

Developers

Category URI

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

Policy Type URI

tmod:@turbot/servicenow-azure-synapseanalytics#/policy/types/synapseWorkspaceServiceNowTableDefinition

GraphQL

query policyType(id: "tmod:@turbot/servicenow-azure-synapseanalytics#/policy/types/synapseWorkspaceServiceNowTableDefinition") { … }

query policySettings(filter: "policyTypeId:'tmod:@turbot/servicenow-azure-synapseanalytics#/policy/types/synapseWorkspaceServiceNowTableDefinition'") { … }

query policyValues(filter: "policyTypeId:'tmod:@turbot/servicenow-azure-synapseanalytics#/policy/types/synapseWorkspaceServiceNowTableDefinition'") { … }

CLI

Get Policy Type

turbot graphql policy-type --id "tmod:@turbot/servicenow-azure-synapseanalytics#/policy/types/synapseWorkspaceServiceNowTableDefinition"

Get Policy Settings

turbot graphql policy-settings --filter "policyTypeId:tmod:@turbot/servicenow-azure-synapseanalytics#/policy/types/synapseWorkspaceServiceNowTableDefinition"

Policy Specification

Schema Type	`object`
Default	table: name: guardrails_azure_synapseanalytics_synapseworkspace label: Azure > Synapse Analytics > Workspace extendsTable: cmdb_ci columns: - name: adla_resource_id label: Adla Resource ID - name: connectivity_endpoints label: Connectivity Endpoints type: string size: 1000 - name: default_data_lake_storage label: Default Data Lake Storage type: string size: 1000 - name: encryption label: Encryption type: string size: 1000 - name: extra_properties label: Extra Properties type: string size: 1000 - name: id label: ID - name: identity label: Identity type: string size: 1000 - name: managed_resource_group_name label: Managed Resource Group Name - name: managed_virtual_network label: Managed Virtual Network - name: managed_virtual_network_settings label: Managed Virtual Network Settings type: string size: 1000 - name: private_endpoint_connections label: Private Endpoint Connections type: string size: 1000 - name: provisioning_state label: Provisioning State - name: public_network_access label: Public Network Access - name: purview_configuration label: Purview Configuration type: string size: 1000 - name: region label: Region - name: region_name label: Region Name type: string size: 200 - name: resource_group label: Resource Group type: string - name: sql_administrator_login label: SQL Administrator Login - name: sql_administrator_login_password label: SQL Administrator Login Password - name: subscription_id label: Subscription ID type: string - name: synapse_workspace_name label: Name - name: tags label: Tags type: string size: 1000 - name: type label: Type - name: virtual_network_profile label: Virtual Network Profile type: string size: 1000 - name: workspace_repository_configuration label: Workspace Repository Configuration type: string size: 1000 - name: workspace_uid label: Workspace UID type: string size: 1000

Schema Type

object

Default

table:
  name: guardrails_azure_synapseanalytics_synapseworkspace
  label: Azure > Synapse Analytics > Workspace
  extendsTable: cmdb_ci
columns:
  - name: adla_resource_id
    label: Adla Resource ID
  - name: connectivity_endpoints
    label: Connectivity Endpoints
    type: string
    size: 1000
  - name: default_data_lake_storage
    label: Default Data Lake Storage
    type: string
    size: 1000
  - name: encryption
    label: Encryption
    type: string
    size: 1000
  - name: extra_properties
    label: Extra Properties
    type: string
    size: 1000
  - name: id
    label: ID
  - name: identity
    label: Identity
    type: string
    size: 1000
  - name: managed_resource_group_name
    label: Managed Resource Group Name
  - name: managed_virtual_network
    label: Managed Virtual Network
  - name: managed_virtual_network_settings
    label: Managed Virtual Network Settings
    type: string
    size: 1000
  - name: private_endpoint_connections
    label: Private Endpoint Connections
    type: string
    size: 1000
  - name: provisioning_state
    label: Provisioning State
  - name: public_network_access
    label: Public Network Access
  - name: purview_configuration
    label: Purview Configuration
    type: string
    size: 1000
  - name: region
    label: Region
  - name: region_name
    label: Region Name
    type: string
    size: 200
  - name: resource_group
    label: Resource Group
    type: string
  - name: sql_administrator_login
    label: SQL Administrator Login
  - name: sql_administrator_login_password
    label: SQL Administrator Login Password
  - name: subscription_id
    label: Subscription ID
    type: string
  - name: synapse_workspace_name
    label: Name
  - name: tags
    label: Tags
    type: string
    size: 1000
  - name: type
    label: Type
  - name: virtual_network_profile
    label: Virtual Network Profile
    type: string
    size: 1000
  - name: workspace_repository_configuration
    label: Workspace Repository Configuration
    type: string
    size: 1000
  - name: workspace_uid
    label: Workspace UID
    type: string
    size: 1000