azure_firewalls

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

Overview

Name	azure_firewalls
Type	Resource
Id	azure.network.azure_firewalls

Fields

vw_azure_firewalls

Name	Datatype	Description
id	text	Resource ID.
name	text	Resource name.
additional_properties	text	field from the properties object
application_rule_collections	text	field from the properties object
autoscale_configuration	text	field from the properties object
azureFirewallName	text	field from the properties object
etag	text	A unique read-only string that changes whenever the resource is updated.
firewall_policy	text	field from the properties object
hub_ip_addresses	text	field from the properties object
ip_configurations	text	field from the properties object
ip_groups	text	field from the properties object
location	text	Resource location.
management_ip_configuration	text	field from the properties object
nat_rule_collections	text	field from the properties object
network_rule_collections	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
sku	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.
threat_intel_mode	text	field from the properties object
type	text	Resource type.
virtual_hub	text	field from the properties object
zones	text	A list of availability zones denoting where the resource needs to come from.

azure_firewalls

Name	Datatype	Description
id	string	Resource ID.
name	string	Resource name.
etag	string	A unique read-only string that changes whenever the resource is updated.
location	string	Resource location.
properties	object	Properties of the Azure Firewall.
tags	object	Resource tags.
type	string	Resource type.
zones	array	A list of availability zones denoting where the resource needs to come from.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	azureFirewallName, resourceGroupName, subscriptionId	Gets the specified Azure Firewall.
list	SELECT	resourceGroupName, subscriptionId	Lists all Azure Firewalls in a resource group.
list_all	SELECT	subscriptionId	Gets all the Azure Firewalls in a subscription.
create_or_update	INSERT	azureFirewallName, resourceGroupName, subscriptionId	Creates or updates the specified Azure Firewall.
delete	DELETE	azureFirewallName, resourceGroupName, subscriptionId	Deletes the specified Azure Firewall.
packet_capture	EXEC	azureFirewallName, resourceGroupName, subscriptionId	Runs a packet capture on AzureFirewall.
update_tags	EXEC	azureFirewallName, resourceGroupName, subscriptionId	Updates tags of an Azure Firewall resource.

SELECT examples

Gets all the Azure Firewalls in a subscription.

vw_azure_firewalls

SELECT
id,
name,
additional_properties,
application_rule_collections,
autoscale_configuration,
azureFirewallName,
etag,
firewall_policy,
hub_ip_addresses,
ip_configurations,
ip_groups,
location,
management_ip_configuration,
nat_rule_collections,
network_rule_collections,
provisioning_state,
resourceGroupName,
sku,
subscriptionId,
tags,
threat_intel_mode,
type,
virtual_hub,
zones
FROM azure.network.vw_azure_firewalls
WHERE subscriptionId = '{{ subscriptionId }}';

azure_firewalls

SELECT
id,
name,
etag,
location,
properties,
tags,
type,
zones
FROM azure.network.azure_firewalls
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.network.azure_firewalls (
azureFirewallName,
resourceGroupName,
subscriptionId,
properties,
zones,
id,
location,
tags
)
SELECT 
'{{ azureFirewallName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ zones }}',
'{{ id }}',
'{{ location }}',
'{{ tags }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: applicationRuleCollections
          value:
            - - name: properties
                value:
                  - name: priority
                    value: integer
                  - name: action
                    value:
                      - name: type
                        value: []
                  - name: rules
                    value:
                      - - name: name
                          value: string
                        - name: description
                          value: string
                        - name: sourceAddresses
                          value:
                            - string
                        - name: protocols
                          value:
                            - - name: protocolType
                                value: []
                              - name: port
                                value: integer
                        - name: targetFqdns
                          value:
                            - string
                        - name: fqdnTags
                          value:
                            - string
                        - name: sourceIpGroups
                          value:
                            - string
                  - name: provisioningState
                    value: []
              - name: name
                value: string
              - name: etag
                value: string
              - name: id
                value: string
        - name: natRuleCollections
          value:
            - - name: properties
                value:
                  - name: priority
                    value: integer
                  - name: action
                    value:
                      - name: type
                        value: []
                  - name: rules
                    value:
                      - - name: name
                          value: string
                        - name: description
                          value: string
                        - name: sourceAddresses
                          value:
                            - string
                        - name: destinationAddresses
                          value:
                            - string
                        - name: destinationPorts
                          value:
                            - string
                        - name: protocols
                          value:
                            - []
                        - name: translatedAddress
                          value: string
                        - name: translatedPort
                          value: string
                        - name: translatedFqdn
                          value: string
                        - name: sourceIpGroups
                          value:
                            - string
              - name: name
                value: string
              - name: etag
                value: string
              - name: id
                value: string
        - name: networkRuleCollections
          value:
            - - name: properties
                value:
                  - name: priority
                    value: integer
                  - name: rules
                    value:
                      - - name: name
                          value: string
                        - name: description
                          value: string
                        - name: protocols
                          value:
                            - []
                        - name: sourceAddresses
                          value:
                            - string
                        - name: destinationAddresses
                          value:
                            - string
                        - name: destinationPorts
                          value:
                            - string
                        - name: destinationFqdns
                          value:
                            - string
                        - name: sourceIpGroups
                          value:
                            - string
                        - name: destinationIpGroups
                          value:
                            - string
              - name: name
                value: string
              - name: etag
                value: string
              - name: id
                value: string
        - name: ipConfigurations
          value:
            - - name: properties
                value:
                  - name: privateIPAddress
                    value: string
                  - name: subnet
                    value:
                      - name: id
                        value: string
              - name: name
                value: string
              - name: etag
                value: string
              - name: type
                value: string
              - name: id
                value: string
        - name: managementIpConfiguration
          value:
            - name: name
              value: string
            - name: etag
              value: string
            - name: type
              value: string
            - name: id
              value: string
        - name: threatIntelMode
          value: []
        - name: hubIPAddresses
          value:
            - name: publicIPs
              value:
                - name: addresses
                  value:
                    - - name: address
                        value: string
                - name: count
                  value: integer
            - name: privateIPAddress
              value: string
        - name: ipGroups
          value: []
        - name: sku
          value:
            - name: name
              value: string
            - name: tier
              value: string
        - name: additionalProperties
          value: []
        - name: autoscaleConfiguration
          value:
            - name: minCapacity
              value: integer
            - name: maxCapacity
              value: integer
    - name: zones
      value:
        - string
    - name: etag
      value: string
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: location
      value: string
    - name: tags
      value: object

DELETE example

Deletes the specified azure_firewalls resource.

/*+ delete */
DELETE FROM azure.network.azure_firewalls
WHERE azureFirewallName = '{{ azureFirewallName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';