managed_instance_administrators

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

Overview

Name	managed_instance_administrators
Type	Resource
Id	azure.sql.managed_instance_administrators

Fields

vw_managed_instance_administrators

Name	Datatype	Description
administratorName	text	field from the properties object
administrator_type	text	field from the properties object
login	text	field from the properties object
managedInstanceName	text	field from the properties object
resourceGroupName	text	field from the properties object
sid	text	field from the properties object
subscriptionId	text	field from the properties object
tenant_id	text	field from the properties object

managed_instance_administrators

Name	Datatype	Description
properties	object	The properties of a managed instance administrator.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	administratorName, managedInstanceName, resourceGroupName, subscriptionId	Gets a managed instance administrator.
create_or_update	INSERT	administratorName, managedInstanceName, resourceGroupName, subscriptionId	Creates or updates a managed instance administrator.
delete	DELETE	administratorName, managedInstanceName, resourceGroupName, subscriptionId	Deletes a managed instance administrator.

SELECT examples

Gets a managed instance administrator.

vw_managed_instance_administrators

SELECT
administratorName,
administrator_type,
login,
managedInstanceName,
resourceGroupName,
sid,
subscriptionId,
tenant_id
FROM azure.sql.vw_managed_instance_administrators
WHERE administratorName = '{{ administratorName }}'
AND managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

managed_instance_administrators

SELECT
properties
FROM azure.sql.managed_instance_administrators
WHERE administratorName = '{{ administratorName }}'
AND managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.sql.managed_instance_administrators (
administratorName,
managedInstanceName,
resourceGroupName,
subscriptionId,
properties
)
SELECT 
'{{ administratorName }}',
'{{ managedInstanceName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: administratorType
          value: string
        - name: login
          value: string
        - name: sid
          value: string
        - name: tenantId
          value: string

DELETE example

Deletes the specified managed_instance_administrators resource.

/*+ delete */
DELETE FROM azure.sql.managed_instance_administrators
WHERE administratorName = '{{ administratorName }}'
AND managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';