databases_principals

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

Overview

Name	databases_principals
Type	Resource
Id	azure.data_explorer.databases_principals

Fields

The following fields are returned by SELECT queries:

list

Successfully retrieved the list of database principals.

Name	Datatype	Description
name	string	Database principal name.
appId	string	Application id - relevant only for application principal type.
email	string	Database principal email if exists.
fqn	string	Database principal fully qualified name.
role	string	Database principal role.
tenantName	string	The tenant name of the principal
type	string	Database principal type.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	resourceGroupName, clusterName, databaseName, subscriptionId		Returns a list of database principals of the given Kusto cluster and database.

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
clusterName	string	The name of the Kusto cluster.
databaseName	string	The name of the database in the Kusto cluster.
resourceGroupName	string	The name of the resource group. The name is case insensitive.
subscriptionId	string	The ID of the target subscription.

SELECT examples

list

Returns a list of database principals of the given Kusto cluster and database.

SELECT
name,
appId,
email,
fqn,
role,
tenantName,
type
FROM azure.data_explorer.databases_principals
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND clusterName = '{{ clusterName }}' -- required
AND databaseName = '{{ databaseName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;