Skip to main content

virtual_network_rules

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

Overview

Namevirtual_network_rules
TypeResource
Idazure.datalake_store.virtual_network_rules

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringThe resource identifier.
namestringThe resource name.
subnetIdstringThe resource identifier for the subnet.
typestringThe resource type.

Methods

The following methods are available for this resource:

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

SELECT examples

Gets the specified Data Lake Store virtual network rule.

SELECT
id,
name,
subnetId,
type
FROM azure.datalake_store.virtual_network_rules
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND account_name = '{{ account_name }}' -- required
AND virtual_network_rule_name = '{{ virtual_network_rule_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

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

INSERT INTO azure.datalake_store.virtual_network_rules (
properties,
resource_group_name,
account_name,
virtual_network_rule_name,
subscription_id
)
SELECT
'{{ properties }}' /* required */,
'{{ resource_group_name }}',
'{{ account_name }}',
'{{ virtual_network_rule_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties,
type
;

UPDATE examples

Updates the specified virtual network rule.

UPDATE azure.datalake_store.virtual_network_rules
SET
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND account_name = '{{ account_name }}' --required
AND virtual_network_rule_name = '{{ virtual_network_rule_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
properties,
type;

REPLACE examples

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

REPLACE azure.datalake_store.virtual_network_rules
SET
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND account_name = '{{ account_name }}' --required
AND virtual_network_rule_name = '{{ virtual_network_rule_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND properties = '{{ properties }}' --required
RETURNING
id,
name,
properties,
type;

DELETE examples

Deletes the specified virtual network rule from the specified Data Lake Store account.

DELETE FROM azure.datalake_store.virtual_network_rules
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND account_name = '{{ account_name }}' --required
AND virtual_network_rule_name = '{{ virtual_network_rule_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;