vw_kpis

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

Overview

Name	vw_kpis
Type	View
Id	azure_extras.customer_insights.vw_kpis

Fields

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

SQL Definition

Sqlite3

SELECT
id as id,
name as name,
type as type,
JSON_EXTRACT(properties, '$.entityType') as "entity_type",
JSON_EXTRACT(properties, '$.entityTypeName') as "entity_type_name",
JSON_EXTRACT(properties, '$.tenantId') as "tenant_id",
JSON_EXTRACT(properties, '$.kpiName') as "kpi_name",
JSON_EXTRACT(properties, '$.displayName') as "display_name",
JSON_EXTRACT(properties, '$.description') as "description",
JSON_EXTRACT(properties, '$.calculationWindow') as "calculation_window",
JSON_EXTRACT(properties, '$.calculationWindowFieldName') as "calculation_window_field_name",
JSON_EXTRACT(properties, '$.function') as "function",
JSON_EXTRACT(properties, '$.expression') as "expression",
JSON_EXTRACT(properties, '$.unit') as "unit",
JSON_EXTRACT(properties, '$.filter') as "filter",
JSON_EXTRACT(properties, '$.groupBy') as "group_by",
JSON_EXTRACT(properties, '$.groupByMetadata') as "group_by_metadata",
JSON_EXTRACT(properties, '$.participantProfilesMetadata') as "participant_profiles_metadata",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.thresHolds') as "thres_holds",
JSON_EXTRACT(properties, '$.aliases') as "aliases",
JSON_EXTRACT(properties, '$.extracts') as "extracts",
subscriptionId,
resourceGroupName,
hubName,
kpiName
FROM azure_extras.customer_insights.kpis
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND hubName = 'replace-me';

Postgres

SELECT
id as id,
name as name,
type as type,
json_extract_path_text(properties, '$.entityType') as "entity_type",
json_extract_path_text(properties, '$.entityTypeName') as "entity_type_name",
json_extract_path_text(properties, '$.tenantId') as "tenant_id",
json_extract_path_text(properties, '$.kpiName') as "kpi_name",
json_extract_path_text(properties, '$.displayName') as "display_name",
json_extract_path_text(properties, '$.description') as "description",
json_extract_path_text(properties, '$.calculationWindow') as "calculation_window",
json_extract_path_text(properties, '$.calculationWindowFieldName') as "calculation_window_field_name",
json_extract_path_text(properties, '$.function') as "function",
json_extract_path_text(properties, '$.expression') as "expression",
json_extract_path_text(properties, '$.unit') as "unit",
json_extract_path_text(properties, '$.filter') as "filter",
json_extract_path_text(properties, '$.groupBy') as "group_by",
json_extract_path_text(properties, '$.groupByMetadata') as "group_by_metadata",
json_extract_path_text(properties, '$.participantProfilesMetadata') as "participant_profiles_metadata",
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.thresHolds') as "thres_holds",
json_extract_path_text(properties, '$.aliases') as "aliases",
json_extract_path_text(properties, '$.extracts') as "extracts",
subscriptionId,
resourceGroupName,
hubName,
kpiName
FROM azure_extras.customer_insights.kpis
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND hubName = 'replace-me';