quotas

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

Overview

Name	quotas
Type	Resource
Id	azure.reservations.quotas

Fields

The following fields are returned by SELECT queries:

get

OK. Returns the paginated quota information.

Name	Datatype	Description
id	string	The quota request ID.
name	string	The name of the quota request.
properties	object	Quota properties for the resource.
type	string	Type of resource. "Microsoft.Capacity/ServiceLimits"

list

OK. Returns the paginated quota information.

Name	Datatype	Description
id	string	The quota request ID.
name	string	The name of the quota request.
properties	object	Quota properties for the resource.
type	string	Type of resource. "Microsoft.Capacity/ServiceLimits"

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	subscriptionId, providerId, location, resourceName		Get the current quota (service limit) and usage of a resource. You can use the response from the GET operation to submit quota update request.
list	select	subscriptionId, providerId, location		Gets a list of current quotas (service limits) and usage for all resources. The response from the list quota operation can be leveraged to request quota updates.
create_or_update	insert	subscriptionId, providerId, location, resourceName		Create or update the quota (service limits) of a resource to the requested value. Steps: 1. Make the Get request to get the quota information for specific resource. 2. To increase the quota, update the limit field in the response from Get request to new value. 3. Submit the JSON to the quota request API to update the quota. The Create quota request may be constructed as follows. The PUT operation can be used to update the quota.
update	update	subscriptionId, providerId, location, resourceName		Update the quota (service limits) of this resource to the requested value. • To get the quota information for specific resource, send a GET request. • To increase the quota, update the limit field from the GET response to a new value. • To update the quota value, submit the JSON response to the quota request API to update the quota. • To update the quota. use the PATCH operation.

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
location	string	Azure region.
providerId	string	Azure resource provider ID.
resourceName	string	The resource name for a resource provider, such as SKU name for Microsoft.Compute, Sku or TotalLowPriorityCores for Microsoft.MachineLearningServices
subscriptionId	string	Azure subscription ID.

SELECT examples

get

Get the current quota (service limit) and usage of a resource. You can use the response from the GET operation to submit quota update request.

SELECT
id,
name,
properties,
type
FROM azure.reservations.quotas
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND providerId = '{{ providerId }}' -- required
AND location = '{{ location }}' -- required
AND resourceName = '{{ resourceName }}' -- required
;

list

Gets a list of current quotas (service limits) and usage for all resources. The response from the list quota operation can be leveraged to request quota updates.

SELECT
id,
name,
properties,
type
FROM azure.reservations.quotas
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND providerId = '{{ providerId }}' -- required
AND location = '{{ location }}' -- required
;

INSERT examples

create_or_update

Create or update the quota (service limits) of a resource to the requested value.
Steps:
1. Make the Get request to get the quota information for specific resource.
2. To increase the quota, update the limit field in the response from Get request to new value.
3. Submit the JSON to the quota request API to update the quota.
The Create quota request may be constructed as follows. The PUT operation can be used to update the quota.

INSERT INTO azure.reservations.quotas (
data__properties,
subscriptionId,
providerId,
location,
resourceName
)
SELECT 
'{{ properties }}',
'{{ subscriptionId }}',
'{{ providerId }}',
'{{ location }}',
'{{ resourceName }}'
RETURNING
id,
name,
properties,
type
;

Manifest

# Description fields are for documentation purposes
- name: quotas
  props:
    - name: subscriptionId
      value: string
      description: Required parameter for the quotas resource.
    - name: providerId
      value: string
      description: Required parameter for the quotas resource.
    - name: location
      value: string
      description: Required parameter for the quotas resource.
    - name: resourceName
      value: string
      description: Required parameter for the quotas resource.
    - name: properties
      value: object
      description: |
        Quota properties for the resource.

UPDATE examples

update

Update the quota (service limits) of this resource to the requested value.
• To get the quota information for specific resource, send a GET request.
• To increase the quota, update the limit field from the GET response to a new value.
• To update the quota value, submit the JSON response to the quota request API to update the quota.
• To update the quota. use the PATCH operation.

UPDATE azure.reservations.quotas
SET 
data__properties = '{{ properties }}'
WHERE 
subscriptionId = '{{ subscriptionId }}' --required
AND providerId = '{{ providerId }}' --required
AND location = '{{ location }}' --required
AND resourceName = '{{ resourceName }}' --required
RETURNING
id,
name,
properties,
type;