vw_reports_latency_scorecards

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

Overview

Name	vw_reports_latency_scorecards
Type	View
Id	azure.front_door.vw_reports_latency_scorecards

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, '$.id') as "id",
JSON_EXTRACT(properties, '$.name') as "name",
JSON_EXTRACT(properties, '$.description') as "description",
JSON_EXTRACT(properties, '$.endpointA') as "endpointa",
JSON_EXTRACT(properties, '$.endpointB') as "endpointb",
JSON_EXTRACT(properties, '$.startDateTimeUTC') as "start_date_time_utc",
JSON_EXTRACT(properties, '$.endDateTimeUTC') as "end_date_time_utc",
JSON_EXTRACT(properties, '$.country') as "country",
JSON_EXTRACT(properties, '$.latencyMetrics') as "latency_metrics",
subscriptionId,
resourceGroupName,
profileName,
experimentName,
aggregationInterval
FROM azure.front_door.reports_latency_scorecards
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND profileName = 'replace-me' AND experimentName = 'replace-me' AND aggregationInterval = 'replace-me';

Postgres

SELECT
id as id,
name as name,
location as location,
type as type,
tags as tags,
json_extract_path_text(properties, '$.id') as "id",
json_extract_path_text(properties, '$.name') as "name",
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, '$.startDateTimeUTC') as "start_date_time_utc",
json_extract_path_text(properties, '$.endDateTimeUTC') as "end_date_time_utc",
json_extract_path_text(properties, '$.country') as "country",
json_extract_path_text(properties, '$.latencyMetrics') as "latency_metrics",
subscriptionId,
resourceGroupName,
profileName,
experimentName,
aggregationInterval
FROM azure.front_door.reports_latency_scorecards
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND profileName = 'replace-me' AND experimentName = 'replace-me' AND aggregationInterval = 'replace-me';