Skip to main content

workspace_aad_admins

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

Overview

Nameworkspace_aad_admins
TypeResource
Idazure.synapse.workspace_aad_admins

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
propertiesobjectWorkspace active directory administrator properties

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, workspaceNameGets a workspace active directory admin
create_or_updateinsertsubscriptionId, resourceGroupName, workspaceNameCreates or updates a workspace active directory admin
deletedeletesubscriptionId, resourceGroupName, workspaceNameDeletes a workspace active directory admin

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.

NameDatatypeDescription
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstringThe ID of the target subscription.
workspaceNamestringThe name of the workspace.

SELECT examples

Gets a workspace active directory admin

SELECT
properties
FROM azure.synapse.workspace_aad_admins
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND workspaceName = '{{ workspaceName }}' -- required
;

INSERT examples

Creates or updates a workspace active directory admin

INSERT INTO azure.synapse.workspace_aad_admins (
data__properties,
subscriptionId,
resourceGroupName,
workspaceName
)
SELECT
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ workspaceName }}'
RETURNING
properties
;

DELETE examples

Deletes a workspace active directory admin

DELETE FROM azure.synapse.workspace_aad_admins
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND workspaceName = '{{ workspaceName }}' --required
;