kusto_pool_database_principal_assignments

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

Overview

Name	kusto_pool_database_principal_assignments
Type	Resource
Id	azure.synapse.kusto_pool_database_principal_assignments

Fields

The following fields are returned by SELECT queries:

get

The Kusto pool database principal assignment object.

Name	Datatype	Description
properties	object	The database principal.
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.

list

OK.

Name	Datatype	Description
properties	object	The database principal.
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	workspaceName, kustoPoolName, databaseName, principalAssignmentName, subscriptionId, resourceGroupName		Gets a Kusto pool database principalAssignment.
list	select	workspaceName, kustoPoolName, databaseName, subscriptionId, resourceGroupName		Lists all Kusto pool database principalAssignments.
create_or_update	insert	workspaceName, kustoPoolName, databaseName, principalAssignmentName, subscriptionId, resourceGroupName		Creates a Kusto pool database principalAssignment.
delete	delete	workspaceName, kustoPoolName, databaseName, principalAssignmentName, subscriptionId, resourceGroupName		Deletes a Kusto pool principalAssignment.
check_name_availability	exec	workspaceName, kustoPoolName, databaseName, subscriptionId, resourceGroupName, name, type		Checks that the database principal assignment is valid and is not already in use.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
databaseName	string	The name of the database in the Kusto pool.
kustoPoolName	string	The name of the Kusto pool.
principalAssignmentName	string	The name of the Kusto principalAssignment.
resourceGroupName	string	The name of the resource group. The name is case insensitive.
subscriptionId	string	The ID of the target subscription.
workspaceName	string	The name of the workspace.

SELECT examples

get

Gets a Kusto pool database principalAssignment.

SELECT
properties,
systemData
FROM azure.synapse.kusto_pool_database_principal_assignments
WHERE workspaceName = '{{ workspaceName }}' -- required
AND kustoPoolName = '{{ kustoPoolName }}' -- required
AND databaseName = '{{ databaseName }}' -- required
AND principalAssignmentName = '{{ principalAssignmentName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
;

list

Lists all Kusto pool database principalAssignments.

SELECT
properties,
systemData
FROM azure.synapse.kusto_pool_database_principal_assignments
WHERE workspaceName = '{{ workspaceName }}' -- required
AND kustoPoolName = '{{ kustoPoolName }}' -- required
AND databaseName = '{{ databaseName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
;

INSERT examples

create_or_update

Creates a Kusto pool database principalAssignment.

INSERT INTO azure.synapse.kusto_pool_database_principal_assignments (
data__properties,
workspaceName,
kustoPoolName,
databaseName,
principalAssignmentName,
subscriptionId,
resourceGroupName
)
SELECT 
'{{ properties }}',
'{{ workspaceName }}',
'{{ kustoPoolName }}',
'{{ databaseName }}',
'{{ principalAssignmentName }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}'
RETURNING
properties,
systemData
;

Manifest

# Description fields are for documentation purposes
- name: kusto_pool_database_principal_assignments
  props:
    - name: workspaceName
      value: string
      description: Required parameter for the kusto_pool_database_principal_assignments resource.
    - name: kustoPoolName
      value: string
      description: Required parameter for the kusto_pool_database_principal_assignments resource.
    - name: databaseName
      value: string
      description: Required parameter for the kusto_pool_database_principal_assignments resource.
    - name: principalAssignmentName
      value: string
      description: Required parameter for the kusto_pool_database_principal_assignments resource.
    - name: subscriptionId
      value: string
      description: Required parameter for the kusto_pool_database_principal_assignments resource.
    - name: resourceGroupName
      value: string
      description: Required parameter for the kusto_pool_database_principal_assignments resource.
    - name: properties
      value: object
      description: |
        The database principal.

DELETE examples

delete

Deletes a Kusto pool principalAssignment.

DELETE FROM azure.synapse.kusto_pool_database_principal_assignments
WHERE workspaceName = '{{ workspaceName }}' --required
AND kustoPoolName = '{{ kustoPoolName }}' --required
AND databaseName = '{{ databaseName }}' --required
AND principalAssignmentName = '{{ principalAssignmentName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
;

Lifecycle Methods

check_name_availability

Checks that the database principal assignment is valid and is not already in use.

EXEC azure.synapse.kusto_pool_database_principal_assignments.check_name_availability 
@workspaceName='{{ workspaceName }}' --required, 
@kustoPoolName='{{ kustoPoolName }}' --required, 
@databaseName='{{ databaseName }}' --required, 
@subscriptionId='{{ subscriptionId }}' --required, 
@resourceGroupName='{{ resourceGroupName }}' --required 
@@json=
'{
"name": "{{ name }}", 
"type": "{{ type }}"
}'
;