kusto_pool_attached_database_configurations

Creates, updates, deletes, gets or lists a kusto_pool_attached_database_configurations resource.

Overview

Name	kusto_pool_attached_database_configurations
Type	Resource
Id	azure.synapse.kusto_pool_attached_database_configurations

Fields

vw_kusto_pool_attached_database_configurations

Name	Datatype	Description
attachedDatabaseConfigurationName	text	field from the properties object
attached_database_names	text	field from the properties object
cluster_resource_id	text	field from the properties object
database_name	text	field from the properties object
default_principals_modification_kind	text	field from the properties object
kustoPoolName	text	field from the properties object
location	text	Resource location.
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
table_level_sharing_properties	text	field from the properties object
workspaceName	text	field from the properties object

kusto_pool_attached_database_configurations

Name	Datatype	Description
location	string	Resource location.
properties	object	Class representing the an attached database configuration properties of kind specific.
systemData	object	Metadata pertaining to creation and last modification of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	attachedDatabaseConfigurationName, kustoPoolName, resourceGroupName, subscriptionId, workspaceName	Returns an attached database configuration.
list_by_kusto_pool	SELECT	kustoPoolName, resourceGroupName, subscriptionId, workspaceName	Returns the list of attached database configurations of the given Kusto Pool.
create_or_update	INSERT	attachedDatabaseConfigurationName, kustoPoolName, resourceGroupName, subscriptionId, workspaceName	Creates or updates an attached database configuration.
delete	DELETE	attachedDatabaseConfigurationName, kustoPoolName, resourceGroupName, subscriptionId, workspaceName	Deletes the attached database configuration with the given name.

SELECT examples

Returns the list of attached database configurations of the given Kusto Pool.

vw_kusto_pool_attached_database_configurations

SELECT
attachedDatabaseConfigurationName,
attached_database_names,
cluster_resource_id,
database_name,
default_principals_modification_kind,
kustoPoolName,
location,
provisioning_state,
resourceGroupName,
subscriptionId,
system_data,
table_level_sharing_properties,
workspaceName
FROM azure.synapse.vw_kusto_pool_attached_database_configurations
WHERE kustoPoolName = '{{ kustoPoolName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

kusto_pool_attached_database_configurations

SELECT
location,
properties,
systemData
FROM azure.synapse.kusto_pool_attached_database_configurations
WHERE kustoPoolName = '{{ kustoPoolName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

INSERT example

Use the following StackQL query and manifest file to create a new kusto_pool_attached_database_configurations resource.

All Properties

/*+ create */
INSERT INTO azure.synapse.kusto_pool_attached_database_configurations (
attachedDatabaseConfigurationName,
kustoPoolName,
resourceGroupName,
subscriptionId,
workspaceName,
location,
properties
)
SELECT 
'{{ attachedDatabaseConfigurationName }}',
'{{ kustoPoolName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ workspaceName }}',
'{{ location }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: location
      value: string
    - name: properties
      value:
        - name: provisioningState
          value: []
        - name: databaseName
          value: string
        - name: clusterResourceId
          value: string
        - name: attachedDatabaseNames
          value:
            - string
        - name: defaultPrincipalsModificationKind
          value: string
        - name: tableLevelSharingProperties
          value:
            - name: tablesToInclude
              value:
                - string
            - name: tablesToExclude
              value:
                - string
            - name: externalTablesToInclude
              value:
                - string
            - name: externalTablesToExclude
              value:
                - string
            - name: materializedViewsToInclude
              value:
                - string
            - name: materializedViewsToExclude
              value:
                - string
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string

DELETE example

Deletes the specified kusto_pool_attached_database_configurations resource.

/*+ delete */
DELETE FROM azure.synapse.kusto_pool_attached_database_configurations
WHERE attachedDatabaseConfigurationName = '{{ attachedDatabaseConfigurationName }}'
AND kustoPoolName = '{{ kustoPoolName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';