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	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 (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	resource_group_name, workspace_name, sql_pool_name, subscription_id		Gets SQL pool usages. 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
resource_group_name	string	The name of the resource group. The name is case insensitive. Required.
sql_pool_name	string	SQL pool name. Required.
subscription_id	string
workspace_name	string	The name of the workspace. Required.

SELECT examples

list

Gets SQL pool usages. Gets SQL pool usages.

SELECT
name,
currentValue,
displayName,
limit,
nextResetTime,
resourceName,
unit
FROM azure.synapse.sql_pool_usages
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND workspace_name = '{{ workspace_name }}' -- required
AND sql_pool_name = '{{ sql_pool_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;