managed_instance_azure_ad_only_authentications

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

Overview

Name	managed_instance_azure_ad_only_authentications
Type	Resource
Id	azure.sql.managed_instance_azure_ad_only_authentications

Fields

vw_managed_instance_azure_ad_only_authentications

Name	Datatype	Description
authenticationName	text	field from the properties object
azure_ad_only_authentication	text	field from the properties object
managedInstanceName	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object

managed_instance_azure_ad_only_authentications

Name	Datatype	Description
properties	object	Properties of a active directory only authentication for Managed Instance.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	authenticationName, managedInstanceName, resourceGroupName, subscriptionId	Gets a specific Azure Active Directory only authentication property.
create_or_update	INSERT	authenticationName, managedInstanceName, resourceGroupName, subscriptionId	Sets Server Active Directory only authentication property or updates an existing server Active Directory only authentication property.
delete	DELETE	authenticationName, managedInstanceName, resourceGroupName, subscriptionId	Deletes an existing server Active Directory only authentication property.

SELECT examples

Gets a specific Azure Active Directory only authentication property.

vw_managed_instance_azure_ad_only_authentications

SELECT
authenticationName,
azure_ad_only_authentication,
managedInstanceName,
resourceGroupName,
subscriptionId
FROM azure.sql.vw_managed_instance_azure_ad_only_authentications
WHERE authenticationName = '{{ authenticationName }}'
AND managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

managed_instance_azure_ad_only_authentications

SELECT
properties
FROM azure.sql.managed_instance_azure_ad_only_authentications
WHERE authenticationName = '{{ authenticationName }}'
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_azure_ad_only_authentications resource.

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: azureADOnlyAuthentication
          value: boolean

DELETE example

Deletes the specified managed_instance_azure_ad_only_authentications resource.

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