data_products

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

Overview

Name	data_products
Type	Resource
Id	azure.network_analytics.data_products

Fields

vw_data_products

Name	Datatype	Description
available_minor_versions	text	field from the properties object
consumption_endpoints	text	field from the properties object
current_minor_version	text	field from the properties object
customer_encryption_key	text	field from the properties object
customer_managed_key_encryption_enabled	text	field from the properties object
dataProductName	text	field from the properties object
documentation	text	field from the properties object
identity	text	Managed service identity (system assigned and/or user assigned identities)
key_vault_url	text	field from the properties object
location	text	The geo-location where the resource lives
major_version	text	field from the properties object
managed_resource_group_configuration	text	field from the properties object
networkacls	text	field from the properties object
owners	text	field from the properties object
private_links_enabled	text	field from the properties object
product	text	field from the properties object
provisioning_state	text	field from the properties object
public_network_access	text	field from the properties object
publisher	text	field from the properties object
purview_account	text	field from the properties object
purview_collection	text	field from the properties object
redundancy	text	field from the properties object
resourceGroupName	text	field from the properties object
resource_guid	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.

data_products

Name	Datatype	Description
identity	object	Managed service identity (system assigned and/or user assigned identities)
location	string	The geo-location where the resource lives
properties	object	The data product properties.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	dataProductName, resourceGroupName, subscriptionId	Retrieve data product resource.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	List data products by resource group.
list_by_subscription	SELECT	subscriptionId	List data products by subscription.
create	INSERT	dataProductName, resourceGroupName, subscriptionId	Create data product resource.
delete	DELETE	dataProductName, resourceGroupName, subscriptionId	Delete data product resource.
update	UPDATE	dataProductName, resourceGroupName, subscriptionId	Update data product resource.
add_user_role	EXEC	dataProductName, resourceGroupName, subscriptionId, data__dataTypeScope, data__principalId, data__principalType, data__role, data__roleId, data__userName	Assign role to the data product.
generate_storage_account_sas_token	EXEC	dataProductName, resourceGroupName, subscriptionId, data__expiryTimeStamp, data__ipAddress, data__startTimeStamp	Generate sas token for storage account.
remove_user_role	EXEC	dataProductName, resourceGroupName, subscriptionId, data__dataTypeScope, data__principalId, data__principalType, data__role, data__roleAssignmentId, data__roleId, data__userName	Remove role from the data product.
rotate_key	EXEC	dataProductName, resourceGroupName, subscriptionId, data__keyVaultUrl	Initiate key rotation on Data Product.

SELECT examples

List data products by subscription.

vw_data_products

SELECT
available_minor_versions,
consumption_endpoints,
current_minor_version,
customer_encryption_key,
customer_managed_key_encryption_enabled,
dataProductName,
documentation,
identity,
key_vault_url,
location,
major_version,
managed_resource_group_configuration,
networkacls,
owners,
private_links_enabled,
product,
provisioning_state,
public_network_access,
publisher,
purview_account,
purview_collection,
redundancy,
resourceGroupName,
resource_guid,
subscriptionId,
tags
FROM azure.network_analytics.vw_data_products
WHERE subscriptionId = '{{ subscriptionId }}';

data_products

SELECT
identity,
location,
properties,
tags
FROM azure.network_analytics.data_products
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.network_analytics.data_products (
dataProductName,
resourceGroupName,
subscriptionId,
properties,
identity,
tags,
location
)
SELECT 
'{{ dataProductName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ identity }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: resourceGuid
          value: string
        - name: provisioningState
          value: []
        - name: publisher
          value: string
        - name: product
          value: string
        - name: majorVersion
          value: string
        - name: owners
          value:
            - string
        - name: redundancy
          value: []
        - name: purviewAccount
          value: string
        - name: purviewCollection
          value: string
        - name: customerEncryptionKey
          value:
            - name: keyVaultUri
              value: string
            - name: keyName
              value: string
            - name: keyVersion
              value: string
        - name: networkacls
          value:
            - name: virtualNetworkRule
              value:
                - - name: id
                    value: string
                  - name: action
                    value: string
                  - name: state
                    value: string
            - name: ipRules
              value:
                - - name: value
                    value: string
                  - name: action
                    value: string
            - name: allowedQueryIpRangeList
              value:
                - string
            - name: defaultAction
              value: []
        - name: managedResourceGroupConfiguration
          value:
            - name: name
              value: string
            - name: location
              value: string
        - name: availableMinorVersions
          value:
            - string
        - name: currentMinorVersion
          value: string
        - name: documentation
          value: string
        - name: consumptionEndpoints
          value:
            - name: ingestionUrl
              value: string
            - name: ingestionResourceId
              value: string
            - name: fileAccessUrl
              value: string
            - name: fileAccessResourceId
              value: string
            - name: queryUrl
              value: string
            - name: queryResourceId
              value: string
        - name: keyVaultUrl
          value: string
    - name: identity
      value:
        - name: principalId
          value: string
        - name: tenantId
          value: string
        - name: type
          value: []
        - name: userAssignedIdentities
          value: []
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a data_products resource.

/*+ update */
UPDATE azure.network_analytics.data_products
SET 
identity = '{{ identity }}',
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
dataProductName = '{{ dataProductName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified data_products resource.

/*+ delete */
DELETE FROM azure.network_analytics.data_products
WHERE dataProductName = '{{ dataProductName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';