data_types

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

Overview

Name	data_types
Type	Resource
Id	azure.network_analytics.data_types

Fields

vw_data_types

Name	Datatype	Description
dataProductName	text	field from the properties object
dataTypeName	text	field from the properties object
database_cache_retention	text	field from the properties object
database_retention	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
state	text	field from the properties object
state_reason	text	field from the properties object
storage_output_retention	text	field from the properties object
subscriptionId	text	field from the properties object
visualization_url	text	field from the properties object

data_types

Name	Datatype	Description
properties	object	The data type properties

Methods

Name	Accessible by	Required Params	Description
get	SELECT	dataProductName, dataTypeName, resourceGroupName, subscriptionId	Retrieve data type resource.
list_by_data_product	SELECT	dataProductName, resourceGroupName, subscriptionId	List data type by parent resource.
create	INSERT	dataProductName, dataTypeName, resourceGroupName, subscriptionId	Create data type resource.
delete	DELETE	dataProductName, dataTypeName, resourceGroupName, subscriptionId	Delete data type resource.
update	UPDATE	dataProductName, dataTypeName, resourceGroupName, subscriptionId	Update data type resource.
generate_storage_container_sas_token	EXEC	dataProductName, dataTypeName, resourceGroupName, subscriptionId, data__expiryTimeStamp, data__ipAddress, data__startTimeStamp	Generate sas token for storage container.

SELECT examples

List data type by parent resource.

vw_data_types

SELECT
dataProductName,
dataTypeName,
database_cache_retention,
database_retention,
provisioning_state,
resourceGroupName,
state,
state_reason,
storage_output_retention,
subscriptionId,
visualization_url
FROM azure.network_analytics.vw_data_types
WHERE dataProductName = '{{ dataProductName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

data_types

SELECT
properties
FROM azure.network_analytics.data_types
WHERE dataProductName = '{{ dataProductName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.network_analytics.data_types (
dataProductName,
dataTypeName,
resourceGroupName,
subscriptionId,
properties
)
SELECT 
'{{ dataProductName }}',
'{{ dataTypeName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: provisioningState
          value: []
        - name: state
          value: []
        - name: stateReason
          value: string
        - name: storageOutputRetention
          value: integer
        - name: databaseCacheRetention
          value: integer
        - name: databaseRetention
          value: integer
        - name: visualizationUrl
          value: string

UPDATE example

Updates a data_types resource.

/*+ update */
UPDATE azure.network_analytics.data_types
SET 
properties = '{{ properties }}'
WHERE 
dataProductName = '{{ dataProductName }}'
AND dataTypeName = '{{ dataTypeName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified data_types resource.

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