Add ActiveQueryCount to REST API property outputs
Provide ActiveQueryCount as a result output under .properties for the REST API database state parameter.
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-manage-compute-rest-api
{
"sku": {
"name": "DataWarehouse",
"tier": "DataWarehouse",
"capacity": 900
},
"kind": "v12.0,user,datawarehouse,gen2",
"properties": {
"collation": "SQL_Latin1_General_CP1_CI_AS",
"maxSizeBytes": 263882790666240,
"status": "Paused",
"databaseId": "e6f5193e-f0f1-4a26-a9b3-66a66bf12e20",
"creationDate": "2019-06-27T14:50:12.197Z",
"currentServiceObjectiveName": "DW100c",
"requestedServiceObjectiveName": "DW100c",
"defaultSecondaryLocation": "centralus",
"catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
"readScale": "Disabled",
"readReplicaCount": 0,
"currentSku": {
"name": "DataWarehouse",
"tier": "DataWarehouse",
"capacity": 900
},
"storageAccountType": "GRS"
},
"location": "eastus2",
"tags": {},
"id": "/subscriptions/eaab21d5-8ecd-4ef0-a0c4-92fac2e22875/resourceGroups/dw/providers/Microsoft.Sql/servers/hiramdw/databases/dw",
"name": "dw",
"type": "Microsoft.Sql/servers/databases"
}
1
vote
Hiram
shared this idea