Skip to main content

firewall_rules

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

Overview

Namefirewall_rules
TypeResource
Idazure.data_lake_store.firewall_rules

Fields

The following fields are returned by SELECT queries:

Successfully retrieved the firewall rule.

NameDatatypeDescription
idstringThe resource identifier.
namestringThe resource name.
propertiesobjectThe firewall rule properties.
typestringThe resource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, accountName, firewallRuleNameGets the specified Data Lake Store firewall rule.
list_by_accountselectsubscriptionId, resourceGroupName, accountNameLists the Data Lake Store firewall rules within the specified Data Lake Store account.
create_or_updateinsertsubscriptionId, resourceGroupName, accountName, firewallRuleName, data__propertiesCreates or updates the specified firewall rule. During update, the firewall rule with the specified name will be replaced with this new firewall rule.
updateupdatesubscriptionId, resourceGroupName, accountName, firewallRuleNameUpdates the specified firewall rule.
deletedeletesubscriptionId, resourceGroupName, accountName, firewallRuleNameDeletes the specified firewall rule from the specified Data Lake Store account.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
accountNamestringThe name of the Data Lake Store account.
firewallRuleNamestringThe name of the firewall rule to delete.
resourceGroupNamestringThe name of the Azure resource group.
subscriptionIdstringGets subscription credentials which uniquely identify Microsoft Azure subscription. The subscription ID forms part of the URI for every service call.

SELECT examples

Gets the specified Data Lake Store firewall rule.

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

INSERT examples

Creates or updates the specified firewall rule. During update, the firewall rule with the specified name will be replaced with this new firewall rule.

INSERT INTO azure.data_lake_store.firewall_rules (
data__properties,
subscriptionId,
resourceGroupName,
accountName,
firewallRuleName
)
SELECT
'{{ properties }}' /* required */,
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ accountName }}',
'{{ firewallRuleName }}'
RETURNING
id,
name,
properties,
type
;

UPDATE examples

Updates the specified firewall rule.

UPDATE azure.data_lake_store.firewall_rules
SET
data__properties = '{{ properties }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND accountName = '{{ accountName }}' --required
AND firewallRuleName = '{{ firewallRuleName }}' --required
RETURNING
id,
name,
properties,
type;

DELETE examples

Deletes the specified firewall rule from the specified Data Lake Store account.

DELETE FROM azure.data_lake_store.firewall_rules
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND accountName = '{{ accountName }}' --required
AND firewallRuleName = '{{ firewallRuleName }}' --required
;