vw_reports_timeseries

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

Overview

Name	vw_reports_timeseries
Type	View
Id	azure.front_door.vw_reports_timeseries

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, '$.endpoint') as "endpoint",
JSON_EXTRACT(properties, '$.startDateTimeUTC') as "start_date_time_utc",
JSON_EXTRACT(properties, '$.endDateTimeUTC') as "end_date_time_utc",
JSON_EXTRACT(properties, '$.aggregationInterval') as "aggregation_interval",
JSON_EXTRACT(properties, '$.timeseriesType') as "timeseries_type",
JSON_EXTRACT(properties, '$.country') as "country",
JSON_EXTRACT(properties, '$.timeseriesData') as "timeseries_data",
subscriptionId,
resourceGroupName,
profileName,
experimentName,
startDateTimeUTC,
endDateTimeUTC,
aggregationInterval,
timeseriesType
FROM azure.front_door.reports_timeseries
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND profileName = 'replace-me' AND experimentName = 'replace-me' AND startDateTimeUTC = 'replace-me' AND endDateTimeUTC = 'replace-me' AND aggregationInterval = 'replace-me' AND timeseriesType = 'replace-me';

Postgres

SELECT
id as id,
name as name,
location as location,
type as type,
tags as tags,
json_extract_path_text(properties, '$.endpoint') as "endpoint",
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, '$.aggregationInterval') as "aggregation_interval",
json_extract_path_text(properties, '$.timeseriesType') as "timeseries_type",
json_extract_path_text(properties, '$.country') as "country",
json_extract_path_text(properties, '$.timeseriesData') as "timeseries_data",
subscriptionId,
resourceGroupName,
profileName,
experimentName,
startDateTimeUTC,
endDateTimeUTC,
aggregationInterval,
timeseriesType
FROM azure.front_door.reports_timeseries
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND profileName = 'replace-me' AND experimentName = 'replace-me' AND startDateTimeUTC = 'replace-me' AND endDateTimeUTC = 'replace-me' AND aggregationInterval = 'replace-me' AND timeseriesType = 'replace-me';