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
;