experiments

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

Overview

Name	experiments
Type	Resource
Id	azure.front_door.experiments

Fields

vw_experiments

Name	Datatype	Description
id	text	Resource ID.
name	text	Resource name.
description	text	field from the properties object
enabled_state	text	field from the properties object
endpointa	text	field from the properties object
endpointb	text	field from the properties object
experimentName	text	field from the properties object
location	text	Resource location.
profileName	text	field from the properties object
resourceGroupName	text	field from the properties object
resource_state	text	field from the properties object
script_file_uri	text	field from the properties object
status	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.
type	text	Resource type.

experiments

Name	Datatype	Description
id	string	Resource ID.
name	string	Resource name.
location	string	Resource location.
properties	object	Defines the properties of an experiment
tags	object	Resource tags.
type	string	Resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	experimentName, profileName, resourceGroupName, subscriptionId
list_by_profile	SELECT	profileName, resourceGroupName, subscriptionId
create_or_update	INSERT	experimentName, profileName, resourceGroupName, subscriptionId
delete	DELETE	experimentName, profileName, resourceGroupName, subscriptionId
update	UPDATE	experimentName, profileName, resourceGroupName, subscriptionId	Updates an Experiment

SELECT examples

vw_experiments

SELECT
id,
name,
description,
enabled_state,
endpointa,
endpointb,
experimentName,
location,
profileName,
resourceGroupName,
resource_state,
script_file_uri,
status,
subscriptionId,
tags,
type
FROM azure.front_door.vw_experiments
WHERE profileName = '{{ profileName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

experiments

SELECT
id,
name,
location,
properties,
tags,
type
FROM azure.front_door.experiments
WHERE profileName = '{{ profileName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.front_door.experiments (
experimentName,
profileName,
resourceGroupName,
subscriptionId,
properties,
location,
tags
)
SELECT 
'{{ experimentName }}',
'{{ profileName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ location }}',
'{{ tags }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: name
      value: string
    - name: properties
      value:
        - name: description
          value: string
        - name: endpointA
          value:
            - name: name
              value: string
            - name: endpoint
              value: string
        - name: enabledState
          value: string
        - name: resourceState
          value: []
        - name: status
          value: string
        - name: scriptFileUri
          value: string
    - name: id
      value: string
    - name: type
      value: string
    - name: location
      value: string
    - name: tags
      value: object

UPDATE example

Updates a experiments resource.

/*+ update */
UPDATE azure.front_door.experiments
SET 
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
experimentName = '{{ experimentName }}'
AND profileName = '{{ profileName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified experiments resource.

/*+ delete */
DELETE FROM azure.front_door.experiments
WHERE experimentName = '{{ experimentName }}'
AND profileName = '{{ profileName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';