virtual_network_rules

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

Overview

Name	virtual_network_rules
Type	Resource
Id	azure.data_lake_store.virtual_network_rules

Fields

vw_virtual_network_rules

Name	Datatype	Description
id	text	The resource identifier.
name	text	The resource name.
accountName	text	field from the properties object
resourceGroupName	text	field from the properties object
subnet_id	text	field from the properties object
subscriptionId	text	field from the properties object
type	text	The resource type.
virtualNetworkRuleName	text	field from the properties object

virtual_network_rules

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

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accountName, resourceGroupName, subscriptionId, virtualNetworkRuleName	Gets the specified Data Lake Store virtual network rule.
list_by_account	SELECT	accountName, resourceGroupName, subscriptionId	Lists the Data Lake Store virtual network rules within the specified Data Lake Store account.
create_or_update	INSERT	accountName, resourceGroupName, subscriptionId, virtualNetworkRuleName, data__properties	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.
delete	DELETE	accountName, resourceGroupName, subscriptionId, virtualNetworkRuleName	Deletes the specified virtual network rule from the specified Data Lake Store account.
update	UPDATE	accountName, resourceGroupName, subscriptionId, virtualNetworkRuleName	Updates the specified virtual network rule.

SELECT examples

Lists the Data Lake Store virtual network rules within the specified Data Lake Store account.

vw_virtual_network_rules

SELECT
id,
name,
accountName,
resourceGroupName,
subnet_id,
subscriptionId,
type,
virtualNetworkRuleName
FROM azure.data_lake_store.vw_virtual_network_rules
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

virtual_network_rules

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

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: subnetId
          value: string

UPDATE example

Updates a virtual_network_rules resource.

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

DELETE example

Deletes the specified virtual_network_rules resource.

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