outbound_firewall_rules

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

Overview

Name	outbound_firewall_rules
Type	Resource
Id	azure.sql.outbound_firewall_rules

Fields

vw_outbound_firewall_rules

Name	Datatype	Description
outboundRuleFqdn	text	field from the properties object
provisioning_state	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

outbound_firewall_rules

Name	Datatype	Description
properties	object	The properties of an outbound firewall rule.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	outboundRuleFqdn, resourceGroupName, serverName, subscriptionId	Gets an outbound firewall rule.
list_by_server	SELECT	resourceGroupName, serverName, subscriptionId	Gets all outbound firewall rules on a server.
create_or_update	INSERT	outboundRuleFqdn, resourceGroupName, serverName, subscriptionId	Create a outbound firewall rule with a given name.
delete	DELETE	outboundRuleFqdn, resourceGroupName, serverName, subscriptionId	Deletes a outbound firewall rule with a given name.

SELECT examples

Gets all outbound firewall rules on a server.

vw_outbound_firewall_rules

SELECT
outboundRuleFqdn,
provisioning_state,
resourceGroupName,
serverName,
subscriptionId
FROM azure.sql.vw_outbound_firewall_rules
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

outbound_firewall_rules

SELECT
properties
FROM azure.sql.outbound_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 outbound_firewall_rules resource.

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: provisioningState
          value: string

DELETE example

Deletes the specified outbound_firewall_rules resource.

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