vw_experiments

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

Overview

Name	vw_experiments
Type	View
Id	azure.front_door.vw_experiments

Fields

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition

Sqlite3

SELECT
id as id,
name as name,
location as location,
type as type,
tags as tags,
JSON_EXTRACT(properties, '$.description') as "description",
JSON_EXTRACT(properties, '$.endpointA') as "endpointa",
JSON_EXTRACT(properties, '$.endpointB') as "endpointb",
JSON_EXTRACT(properties, '$.enabledState') as "enabled_state",
JSON_EXTRACT(properties, '$.resourceState') as "resource_state",
JSON_EXTRACT(properties, '$.status') as "status",
JSON_EXTRACT(properties, '$.scriptFileUri') as "script_file_uri",
subscriptionId,
resourceGroupName,
profileName,
experimentName
FROM azure.front_door.experiments
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND profileName = 'replace-me';

Postgres

SELECT
id as id,
name as name,
location as location,
type as type,
tags as tags,
json_extract_path_text(properties, '$.description') as "description",
json_extract_path_text(properties, '$.endpointA') as "endpointa",
json_extract_path_text(properties, '$.endpointB') as "endpointb",
json_extract_path_text(properties, '$.enabledState') as "enabled_state",
json_extract_path_text(properties, '$.resourceState') as "resource_state",
json_extract_path_text(properties, '$.status') as "status",
json_extract_path_text(properties, '$.scriptFileUri') as "script_file_uri",
subscriptionId,
resourceGroupName,
profileName,
experimentName
FROM azure.front_door.experiments
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND profileName = 'replace-me';