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:

check_name_availability

Name	Datatype	Description
name	string	The name that was checked.
message	string	Message indicating an unavailable name due to a conflict, or a description of the naming rules that are violated.
nameAvailable	boolean	Specifies a Boolean value that indicates if the name is available.
reason	string	Message providing the reason why the given name is invalid. Known values are: "Invalid" and "AlreadyExists".

get

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
aadObjectId	string	The service principal object id in AAD (Azure active directory).
principalId	string	The principal ID assigned to the database principal. It can be a user email, application ID, or security group name.
principalName	string	The principal name.
principalType	string	Principal type. Known values are: "App", "Group", and "User".
provisioningState	string	The provisioned state of the resource. Known values are: "Running", "Creating", "Deleting", "Succeeded", "Failed", "Moving", and "Canceled".
role	string	Database principal role. Known values are: "Admin", "Ingestor", "Monitor", "User", "UnrestrictedViewer", and "Viewer".
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
tenantId	string	The tenant id of the principal.
tenantName	string	The tenant name of the principal.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

list

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
aadObjectId	string	The service principal object id in AAD (Azure active directory).
principalId	string	The principal ID assigned to the database principal. It can be a user email, application ID, or security group name.
principalName	string	The principal name.
principalType	string	Principal type. Known values are: "App", "Group", and "User".
provisioningState	string	The provisioned state of the resource. Known values are: "Running", "Creating", "Deleting", "Succeeded", "Failed", "Moving", and "Canceled".
role	string	Database principal role. Known values are: "Admin", "Ingestor", "Monitor", "User", "UnrestrictedViewer", and "Viewer".
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
tenantId	string	The tenant id of the principal.
tenantName	string	The tenant name of the principal.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
check_name_availability	select	workspace_name, kusto_pool_name, database_name, resource_group_name, subscription_id		Checks that the database principal assignment is valid and is not already in use.
get	select	workspace_name, kusto_pool_name, database_name, principal_assignment_name, resource_group_name, subscription_id		Gets a Kusto pool database principalAssignment.
list	select	workspace_name, kusto_pool_name, database_name, resource_group_name, subscription_id		Lists all Kusto pool database principalAssignments.
create_or_update	insert	workspace_name, kusto_pool_name, database_name, principal_assignment_name, resource_group_name, subscription_id		Creates a Kusto pool database principalAssignment.
create_or_update	replace	workspace_name, kusto_pool_name, database_name, principal_assignment_name, resource_group_name, subscription_id		Creates a Kusto pool database principalAssignment.
delete	delete	workspace_name, kusto_pool_name, database_name, principal_assignment_name, resource_group_name, subscription_id		Deletes a Kusto pool principalAssignment.

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
database_name	string	The name of the database in the Kusto pool. Required.
kusto_pool_name	string	The name of the Kusto pool. Required.
principal_assignment_name	string	The name of the Kusto principalAssignment. Required.
resource_group_name	string	The name of the resource group. The name is case insensitive. Required.
subscription_id	string
workspace_name	string	The name of the workspace. Required.

SELECT examples

check_name_availability

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

SELECT
name,
message,
nameAvailable,
reason
FROM azure.synapse.kusto_pool_database_principal_assignments
WHERE workspace_name = '{{ workspace_name }}' -- required
AND kusto_pool_name = '{{ kusto_pool_name }}' -- required
AND database_name = '{{ database_name }}' -- required
AND resource_group_name = '{{ resource_group_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

get

Gets a Kusto pool database principalAssignment.

SELECT
id,
name,
aadObjectId,
principalId,
principalName,
principalType,
provisioningState,
role,
systemData,
tenantId,
tenantName,
type
FROM azure.synapse.kusto_pool_database_principal_assignments
WHERE workspace_name = '{{ workspace_name }}' -- required
AND kusto_pool_name = '{{ kusto_pool_name }}' -- required
AND database_name = '{{ database_name }}' -- required
AND principal_assignment_name = '{{ principal_assignment_name }}' -- required
AND resource_group_name = '{{ resource_group_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

list

Lists all Kusto pool database principalAssignments.

SELECT
id,
name,
aadObjectId,
principalId,
principalName,
principalType,
provisioningState,
role,
systemData,
tenantId,
tenantName,
type
FROM azure.synapse.kusto_pool_database_principal_assignments
WHERE workspace_name = '{{ workspace_name }}' -- required
AND kusto_pool_name = '{{ kusto_pool_name }}' -- required
AND database_name = '{{ database_name }}' -- required
AND resource_group_name = '{{ resource_group_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

create_or_update

Creates a Kusto pool database principalAssignment.

INSERT INTO azure.synapse.kusto_pool_database_principal_assignments (
properties,
workspace_name,
kusto_pool_name,
database_name,
principal_assignment_name,
resource_group_name,
subscription_id
)
SELECT 
'{{ properties }}',
'{{ workspace_name }}',
'{{ kusto_pool_name }}',
'{{ database_name }}',
'{{ principal_assignment_name }}',
'{{ resource_group_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties,
systemData,
type
;

Manifest

# Description fields are for documentation purposes
- name: kusto_pool_database_principal_assignments
props:
  - name: workspace_name
    value: "{{ workspace_name }}"
    description: Required parameter for the kusto_pool_database_principal_assignments resource.
  - name: kusto_pool_name
    value: "{{ kusto_pool_name }}"
    description: Required parameter for the kusto_pool_database_principal_assignments resource.
  - name: database_name
    value: "{{ database_name }}"
    description: Required parameter for the kusto_pool_database_principal_assignments resource.
  - name: principal_assignment_name
    value: "{{ principal_assignment_name }}"
    description: Required parameter for the kusto_pool_database_principal_assignments resource.
  - name: resource_group_name
    value: "{{ resource_group_name }}"
    description: Required parameter for the kusto_pool_database_principal_assignments resource.
  - name: subscription_id
    value: "{{ subscription_id }}"
    description: Required parameter for the kusto_pool_database_principal_assignments resource.
  - name: properties
    value:
      principalId: "{{ principalId }}"
      role: "{{ role }}"
      tenantId: "{{ tenantId }}"
      principalType: "{{ principalType }}"

REPLACE examples

create_or_update

Creates a Kusto pool database principalAssignment.

REPLACE azure.synapse.kusto_pool_database_principal_assignments
SET 
properties = '{{ properties }}'
WHERE 
workspace_name = '{{ workspace_name }}' --required
AND kusto_pool_name = '{{ kusto_pool_name }}' --required
AND database_name = '{{ database_name }}' --required
AND principal_assignment_name = '{{ principal_assignment_name }}' --required
AND resource_group_name = '{{ resource_group_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

DELETE examples

delete

Deletes a Kusto pool principalAssignment.

DELETE FROM azure.synapse.kusto_pool_database_principal_assignments
WHERE workspace_name = '{{ workspace_name }}' --required
AND kusto_pool_name = '{{ kusto_pool_name }}' --required
AND database_name = '{{ database_name }}' --required
AND principal_assignment_name = '{{ principal_assignment_name }}' --required
AND resource_group_name = '{{ resource_group_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;