vw_workload_classifiers
Creates, updates, deletes, gets or lists a vw_workload_classifiers resource.
Overview
| Name | vw_workload_classifiers |
| Type | View |
| Id | azure.sql.vw_workload_classifiers |
Fields
See the SQL Definition (view DDL) for fields returned by this view.
SQL Definition
- Sqlite3
- Postgres
SELECT
JSON_EXTRACT(properties, '$.memberName') as "member_name",
JSON_EXTRACT(properties, '$.label') as "label",
JSON_EXTRACT(properties, '$.context') as "context",
JSON_EXTRACT(properties, '$.startTime') as "start_time",
JSON_EXTRACT(properties, '$.endTime') as "end_time",
JSON_EXTRACT(properties, '$.importance') as "importance",
subscriptionId,
resourceGroupName,
serverName,
databaseName,
workloadGroupName,
workloadClassifierName
FROM azure.sql.workload_classifiers
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND serverName = 'replace-me' AND databaseName = 'replace-me' AND workloadGroupName = 'replace-me';
SELECT
json_extract_path_text(properties, '$.memberName') as "member_name",
json_extract_path_text(properties, '$.label') as "label",
json_extract_path_text(properties, '$.context') as "context",
json_extract_path_text(properties, '$.startTime') as "start_time",
json_extract_path_text(properties, '$.endTime') as "end_time",
json_extract_path_text(properties, '$.importance') as "importance",
subscriptionId,
resourceGroupName,
serverName,
databaseName,
workloadGroupName,
workloadClassifierName
FROM azure.sql.workload_classifiers
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND serverName = 'replace-me' AND databaseName = 'replace-me' AND workloadGroupName = 'replace-me';