sql_pool_usages

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

Overview

Name	sql_pool_usages
Type	Resource
Id	azure.synapse.sql_pool_usages

Fields

The following fields are returned by SELECT queries:

list

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

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	subscriptionId, resourceGroupName, workspaceName, sqlPoolName		Gets SQL pool usages.

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.
sqlPoolName	string	SQL pool name
subscriptionId	string	The ID of the target subscription.
workspaceName	string	The name of the workspace.

SELECT examples

list

Gets SQL pool usages.

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