server_azure_ad_only_authentications

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

Overview

Name	server_azure_ad_only_authentications
Type	Resource
Id	azure.sql.server_azure_ad_only_authentications

Fields

vw_server_azure_ad_only_authentications

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

server_azure_ad_only_authentications

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

Methods

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

SELECT examples

Gets a list of server Azure Active Directory only authentications.

vw_server_azure_ad_only_authentications

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

server_azure_ad_only_authentications

SELECT
properties
FROM azure.sql.server_azure_ad_only_authentications
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

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

Manifest

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

DELETE example

Deletes the specified server_azure_ad_only_authentications resource.

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