firewall_rules

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

Overview

Name	firewall_rules
Type	Resource
Id	azure.data_lake_store.firewall_rules

Fields

vw_firewall_rules

Name	Datatype	Description
id	text	The resource identifier.
name	text	The resource name.
accountName	text	field from the properties object
end_ip_address	text	field from the properties object
firewallRuleName	text	field from the properties object
resourceGroupName	text	field from the properties object
start_ip_address	text	field from the properties object
subscriptionId	text	field from the properties object
type	text	The resource type.

firewall_rules

Name	Datatype	Description
id	string	The resource identifier.
name	string	The resource name.
properties	object	The firewall rule properties.
type	string	The resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accountName, firewallRuleName, resourceGroupName, subscriptionId	Gets the specified Data Lake Store firewall rule.
list_by_account	SELECT	accountName, resourceGroupName, subscriptionId	Lists the Data Lake Store firewall rules within the specified Data Lake Store account.
create_or_update	INSERT	accountName, firewallRuleName, resourceGroupName, subscriptionId, data__properties	Creates or updates the specified firewall rule. During update, the firewall rule with the specified name will be replaced with this new firewall rule.
delete	DELETE	accountName, firewallRuleName, resourceGroupName, subscriptionId	Deletes the specified firewall rule from the specified Data Lake Store account.
update	UPDATE	accountName, firewallRuleName, resourceGroupName, subscriptionId	Updates the specified firewall rule.

SELECT examples

Lists the Data Lake Store firewall rules within the specified Data Lake Store account.

vw_firewall_rules

SELECT
id,
name,
accountName,
end_ip_address,
firewallRuleName,
resourceGroupName,
start_ip_address,
subscriptionId,
type
FROM azure.data_lake_store.vw_firewall_rules
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

firewall_rules

SELECT
id,
name,
properties,
type
FROM azure.data_lake_store.firewall_rules
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.data_lake_store.firewall_rules (
accountName,
firewallRuleName,
resourceGroupName,
subscriptionId,
data__properties,
properties
)
SELECT 
'{{ accountName }}',
'{{ firewallRuleName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: startIpAddress
          value: string
        - name: endIpAddress
          value: string

UPDATE example

Updates a firewall_rules resource.

/*+ update */
UPDATE azure.data_lake_store.firewall_rules
SET 
properties = '{{ properties }}'
WHERE 
accountName = '{{ accountName }}'
AND firewallRuleName = '{{ firewallRuleName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified firewall_rules resource.

/*+ delete */
DELETE FROM azure.data_lake_store.firewall_rules
WHERE accountName = '{{ accountName }}'
AND firewallRuleName = '{{ firewallRuleName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';