workspace_managed_sql_server_usages

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

Overview

Name	workspace_managed_sql_server_usages
Type	Resource
Id	azure.synapse.workspace_managed_sql_server_usages

Fields

The following fields are returned by SELECT queries:

list

Name	Datatype	Description
name	string	Name of the server usage metric.
currentValue	number (double)	The current value of the metric.
displayName	string	The metric display name.
limit	number (double)	The current limit of the metric.
nextResetTime	string (date-time)	The next reset time for the metric (ISO8601 format).
resourceName	string	The name of the resource.
unit	string	The units of the metric.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	subscriptionId, resourceGroupName, workspaceName		Get list of server usages metric for workspace managed sql server.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
resourceGroupName	string	The name of the resource group. The name is case insensitive.
subscriptionId	string	The ID of the target subscription.
workspaceName	string	The name of the workspace.

SELECT examples

list

Get list of server usages metric for workspace managed sql server.

SELECT
name,
currentValue,
displayName,
limit,
nextResetTime,
resourceName,
unit
FROM azure.synapse.workspace_managed_sql_server_usages
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND workspaceName = '{{ workspaceName }}' -- required
;