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

Name	Datatype	Description
name	string	The name of the usage metric.
currentValue	number	The current value of the usage metric.
displayName	string	The usage metric display name.
limit	number	The current limit of the usage metric.
nextResetTime	string	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

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

SELECT examples

Gets SQL pool usages.

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