ipv6_firewall_rules

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

Overview

Name	ipv6_firewall_rules
Type	Resource
Id	azure.sql.ipv6_firewall_rules

Fields

vw_ipv6_firewall_rules

Name	Datatype	Description
end_ipv6_address	text	field from the properties object
firewallRuleName	text	field from the properties object
resourceGroupName	text	field from the properties object
serverName	text	field from the properties object
start_ipv6_address	text	field from the properties object
subscriptionId	text	field from the properties object

ipv6_firewall_rules

Name	Datatype	Description
properties	object	The properties of an IPv6 server firewall rule.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	firewallRuleName, resourceGroupName, serverName, subscriptionId	Gets an IPv6 firewall rule.
list_by_server	SELECT	resourceGroupName, serverName, subscriptionId	Gets a list of IPv6 firewall rules.
create_or_update	INSERT	firewallRuleName, resourceGroupName, serverName, subscriptionId	Creates or updates an IPv6 firewall rule.
delete	DELETE	firewallRuleName, resourceGroupName, serverName, subscriptionId	Deletes an IPv6 firewall rule.

SELECT examples

Gets a list of IPv6 firewall rules.

vw_ipv6_firewall_rules

SELECT
end_ipv6_address,
firewallRuleName,
resourceGroupName,
serverName,
start_ipv6_address,
subscriptionId
FROM azure.sql.vw_ipv6_firewall_rules
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

ipv6_firewall_rules

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

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: startIPv6Address
          value: string
        - name: endIPv6Address
          value: string

DELETE example

Deletes the specified ipv6_firewall_rules resource.

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