quotas

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

Overview

Name	quotas
Type	Resource
Id	azure.reservations.quotas

Fields

vw_quotas

Name	Datatype	Description
id	text	The quota request ID.
name	text	The name of the quota request.
current_value	text	field from the properties object
limit	text	field from the properties object
location	text	field from the properties object
properties	text	Quota properties for the resource.
providerId	text	field from the properties object
quota_period	text	field from the properties object
resourceName	text	field from the properties object
resource_type	text	field from the properties object
subscriptionId	text	field from the properties object
type	text	Type of resource. "Microsoft.Capacity/ServiceLimits"
unit	text	field from the properties object

quotas

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

Name	Accessible by	Required Params	Description
get	SELECT	location, providerId, resourceName, subscriptionId	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	location, providerId, subscriptionId	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	location, providerId, resourceName, subscriptionId	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 | location, providerId, resourceName, subscriptionId | 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. |

SELECT examples

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.

vw_quotas

SELECT
id,
name,
current_value,
limit,
location,
properties,
providerId,
quota_period,
resourceName,
resource_type,
subscriptionId,
type,
unit
FROM azure.reservations.vw_quotas
WHERE location = '{{ location }}'
AND providerId = '{{ providerId }}'
AND subscriptionId = '{{ subscriptionId }}';

quotas

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

INSERT example

Use the following StackQL query and manifest file to create a new quotas resource.

All Properties

/*+ create */
INSERT INTO azure.reservations.quotas (
location,
providerId,
resourceName,
subscriptionId,
properties
)
SELECT 
'{{ location }}',
'{{ providerId }}',
'{{ resourceName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: properties
      value:
        - name: limit
          value: integer
        - name: currentValue
          value: integer
        - name: unit
          value: string
        - name: name
          value:
            - name: value
              value: string
            - name: localizedValue
              value: string
        - name: resourceType
          value: []
        - name: quotaPeriod
          value: string
        - name: properties
          value: object

UPDATE example

Updates a quotas resource.

/*+ update */
UPDATE azure.reservations.quotas
SET 
properties = '{{ properties }}'
WHERE 
location = '{{ location }}'
AND providerId = '{{ providerId }}'
AND resourceName = '{{ resourceName }}'
AND subscriptionId = '{{ subscriptionId }}';