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	The current value of the metric.
displayName	string	The metric display name.
limit	number	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	resource_group_name, workspace_name, subscription_id		Get list of usages metric for the server. 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
resource_group_name	string	The name of the resource group. The name is case insensitive. Required.
subscription_id	string
workspace_name	string	The name of the workspace. Required.

SELECT examples

list

Get list of usages metric for the server. 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 resource_group_name = '{{ resource_group_name }}' -- required
AND workspace_name = '{{ workspace_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;