dns_resolvers

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

Overview

Name	dns_resolvers
Type	Resource
Id	azure.dns_resolver.dns_resolvers

Fields

vw_dns_resolvers

Name	Datatype	Description
dnsResolverName	text	field from the properties object
dns_resolver_state	text	field from the properties object
etag	text	ETag of the DNS resolver.
location	text	The geo-location where the resource lives
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
resource_guid	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
tags	text	Resource tags.
virtual_network	text	field from the properties object

dns_resolvers

Name	Datatype	Description
etag	string	ETag of the DNS resolver.
location	string	The geo-location where the resource lives
properties	object	Represents the properties of a DNS resolver.
systemData	object	Metadata pertaining to creation and last modification of the resource.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	dnsResolverName, resourceGroupName, subscriptionId	Gets properties of a DNS resolver.
list	SELECT	subscriptionId	Lists DNS resolvers in all resource groups of a subscription.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Lists DNS resolvers within a resource group.
list_by_virtual_network	SELECT	resourceGroupName, subscriptionId, virtualNetworkName	Lists DNS resolver resource IDs linked to a virtual network.
create_or_update	INSERT	dnsResolverName, resourceGroupName, subscriptionId, data__properties	Creates or updates a DNS resolver.
delete	DELETE	dnsResolverName, resourceGroupName, subscriptionId	Deletes a DNS resolver. WARNING: This operation cannot be undone.
update	UPDATE	dnsResolverName, resourceGroupName, subscriptionId	Updates a DNS resolver.

SELECT examples

Lists DNS resolvers in all resource groups of a subscription.

vw_dns_resolvers

SELECT
dnsResolverName,
dns_resolver_state,
etag,
location,
provisioning_state,
resourceGroupName,
resource_guid,
subscriptionId,
system_data,
tags,
virtual_network
FROM azure.dns_resolver.vw_dns_resolvers
WHERE subscriptionId = '{{ subscriptionId }}';

dns_resolvers

SELECT
etag,
location,
properties,
systemData,
tags
FROM azure.dns_resolver.dns_resolvers
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.dns_resolver.dns_resolvers (
dnsResolverName,
resourceGroupName,
subscriptionId,
data__properties,
properties,
tags,
location
)
SELECT 
'{{ dnsResolverName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ properties }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: etag
      value: string
    - name: properties
      value:
        - name: virtualNetwork
          value:
            - name: id
              value: string
        - name: dnsResolverState
          value: string
        - name: provisioningState
          value: []
        - name: resourceGuid
          value: []
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a dns_resolvers resource.

/*+ update */
UPDATE azure.dns_resolver.dns_resolvers
SET 
tags = '{{ tags }}'
WHERE 
dnsResolverName = '{{ dnsResolverName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified dns_resolvers resource.

/*+ delete */
DELETE FROM azure.dns_resolver.dns_resolvers
WHERE dnsResolverName = '{{ dnsResolverName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';