reference_data_sets

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

Overview

Name	reference_data_sets
Type	Resource
Id	azure.time_series_insights.reference_data_sets

Fields

vw_reference_data_sets

Name	Datatype	Description
creation_time	text	field from the properties object
data_string_comparison_behavior	text	field from the properties object
environmentName	text	field from the properties object
key_properties	text	field from the properties object
location	text	Resource location
provisioning_state	text	field from the properties object
referenceDataSetName	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags

reference_data_sets

Name	Datatype	Description
location	string	Resource location
properties	object	Properties of the reference data set.
tags	object	Resource tags

Methods

Name	Accessible by	Required Params	Description
get	SELECT	environmentName, referenceDataSetName, resourceGroupName, subscriptionId	Gets the reference data set with the specified name in the specified environment.
list_by_environment	SELECT	environmentName, resourceGroupName, subscriptionId	Lists all the available reference data sets associated with the subscription and within the specified resource group and environment.
create_or_update	INSERT	environmentName, referenceDataSetName, resourceGroupName, subscriptionId, data__properties	Create or update a reference data set in the specified environment.
delete	DELETE	environmentName, referenceDataSetName, resourceGroupName, subscriptionId	Deletes the reference data set with the specified name in the specified subscription, resource group, and environment
update	UPDATE	environmentName, referenceDataSetName, resourceGroupName, subscriptionId	Updates the reference data set with the specified name in the specified subscription, resource group, and environment.

SELECT examples

Lists all the available reference data sets associated with the subscription and within the specified resource group and environment.

vw_reference_data_sets

SELECT
creation_time,
data_string_comparison_behavior,
environmentName,
key_properties,
location,
provisioning_state,
referenceDataSetName,
resourceGroupName,
subscriptionId,
tags
FROM azure.time_series_insights.vw_reference_data_sets
WHERE environmentName = '{{ environmentName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

reference_data_sets

SELECT
location,
properties,
tags
FROM azure.time_series_insights.reference_data_sets
WHERE environmentName = '{{ environmentName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.time_series_insights.reference_data_sets (
environmentName,
referenceDataSetName,
resourceGroupName,
subscriptionId,
data__properties,
properties,
location,
tags
)
SELECT 
'{{ environmentName }}',
'{{ referenceDataSetName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ properties }}',
'{{ location }}',
'{{ tags }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: keyProperties
          value:
            - - name: name
                value: string
              - name: type
                value: string
        - name: dataStringComparisonBehavior
          value: string
    - name: location
      value: string
    - name: tags
      value: object

UPDATE example

Updates a reference_data_sets resource.

/*+ update */
UPDATE azure.time_series_insights.reference_data_sets
SET 
tags = '{{ tags }}'
WHERE 
environmentName = '{{ environmentName }}'
AND referenceDataSetName = '{{ referenceDataSetName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified reference_data_sets resource.

/*+ delete */
DELETE FROM azure.time_series_insights.reference_data_sets
WHERE environmentName = '{{ environmentName }}'
AND referenceDataSetName = '{{ referenceDataSetName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';