managed_instance_dtcs

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

Overview

Name	managed_instance_dtcs
Type	Resource
Id	azure.sql.managed_instance_dtcs

Fields

vw_managed_instance_dtcs

Name	Datatype	Description
dtcName	text	field from the properties object
dtc_enabled	text	field from the properties object
dtc_host_name_dns_suffix	text	field from the properties object
external_dns_suffix_search_list	text	field from the properties object
managedInstanceName	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
security_settings	text	field from the properties object
subscriptionId	text	field from the properties object

managed_instance_dtcs

Name	Datatype	Description
properties	object	The properties of managed instance DTC.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	dtcName, managedInstanceName, resourceGroupName, subscriptionId	Gets managed instance DTC settings.
create_or_update	INSERT	dtcName, managedInstanceName, resourceGroupName, subscriptionId	Updates managed instance DTC settings.

SELECT examples

Gets managed instance DTC settings.

vw_managed_instance_dtcs

SELECT
dtcName,
dtc_enabled,
dtc_host_name_dns_suffix,
external_dns_suffix_search_list,
managedInstanceName,
provisioning_state,
resourceGroupName,
security_settings,
subscriptionId
FROM azure.sql.vw_managed_instance_dtcs
WHERE dtcName = '{{ dtcName }}'
AND managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

managed_instance_dtcs

SELECT
properties
FROM azure.sql.managed_instance_dtcs
WHERE dtcName = '{{ dtcName }}'
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_dtcs resource.

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: dtcEnabled
          value: boolean
        - name: securitySettings
          value:
            - name: transactionManagerCommunicationSettings
              value:
                - name: allowInboundEnabled
                  value: boolean
                - name: allowOutboundEnabled
                  value: boolean
                - name: authentication
                  value: string
            - name: xaTransactionsEnabled
              value: boolean
            - name: snaLu6point2TransactionsEnabled
              value: boolean
            - name: xaTransactionsDefaultTimeout
              value: integer
            - name: xaTransactionsMaximumTimeout
              value: integer
        - name: externalDnsSuffixSearchList
          value:
            - string
        - name: dtcHostNameDnsSuffix
          value: string
        - name: provisioningState
          value: string