Skip to main content

firewall_rules

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

Overview

Namefirewall_rules
TypeResource
Idazure.datalake_analytics.firewall_rules

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringThe resource identifier.
namestringThe resource name.
endIpAddressstringThe end IP address for the firewall rule. This can be either ipv4 or ipv6. Start and End should be in the same protocol.
startIpAddressstringThe start IP address for the firewall rule. This can be either ipv4 or ipv6. Start and End should be in the same protocol.
typestringThe resource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, account_name, firewall_rule_name, subscription_idGets the specified Data Lake Analytics firewall rule.
list_by_accountselectresource_group_name, account_name, subscription_idLists the Data Lake Analytics firewall rules within the specified Data Lake Analytics account.
create_or_updateinsertresource_group_name, account_name, firewall_rule_name, subscription_id, propertiesCreates or updates the specified firewall rule. During update, the firewall rule with the specified name will be replaced with this new firewall rule.
updateupdateresource_group_name, account_name, firewall_rule_name, subscription_idUpdates the specified firewall rule.
create_or_updatereplaceresource_group_name, account_name, firewall_rule_name, subscription_id, propertiesCreates or updates the specified firewall rule. During update, the firewall rule with the specified name will be replaced with this new firewall rule.
deletedeleteresource_group_name, account_name, firewall_rule_name, subscription_idDeletes the specified firewall rule from the specified Data Lake Analytics 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
account_namestringThe name of the Data Lake Analytics account. Required.
firewall_rule_namestringThe name of the firewall rule to delete. Required.
resource_group_namestringThe name of the Azure resource group. Required.
subscription_idstring

SELECT examples

Gets the specified Data Lake Analytics firewall rule.

SELECT
id,
name,
endIpAddress,
startIpAddress,
type
FROM azure.datalake_analytics.firewall_rules
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND account_name = '{{ account_name }}' -- required
AND firewall_rule_name = '{{ firewall_rule_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- 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.datalake_analytics.firewall_rules (
properties,
resource_group_name,
account_name,
firewall_rule_name,
subscription_id
)
SELECT
'{{ properties }}' /* required */,
'{{ resource_group_name }}',
'{{ account_name }}',
'{{ firewall_rule_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties,
type
;

UPDATE examples

Updates the specified firewall rule.

UPDATE azure.datalake_analytics.firewall_rules
SET
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND account_name = '{{ account_name }}' --required
AND firewall_rule_name = '{{ firewall_rule_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
properties,
type;

REPLACE 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.

REPLACE azure.datalake_analytics.firewall_rules
SET
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND account_name = '{{ account_name }}' --required
AND firewall_rule_name = '{{ firewall_rule_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND properties = '{{ properties }}' --required
RETURNING
id,
name,
properties,
type;

DELETE examples

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

DELETE FROM azure.datalake_analytics.firewall_rules
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND account_name = '{{ account_name }}' --required
AND firewall_rule_name = '{{ firewall_rule_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;