quotas

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

Overview

Name	quotas
Type	Resource
Id	azure.quota.quotas

Fields

vw_quotas

Name	Datatype	Description
id	text	The resource ID.
name	text	The resource name.
is_quota_applicable	text	field from the properties object
limit	text	field from the properties object
properties	text	Quota properties for the specified resource.
quota_period	text	field from the properties object
resourceName	text	field from the properties object
resource_type	text	field from the properties object
scope	text	field from the properties object
type	text	The resource type.
unit	text	field from the properties object

quotas

Name	Datatype	Description
id	string	The resource ID.
name	string	The resource name.
properties	object	Quota properties for the specified resource.
type	string	The resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceName, scope	Get the quota limit of a resource. The response can be used to determine the remaining quota to calculate a new quota limit that can be submitted with a PUT request.
list	SELECT	scope	Get a list of current quota limits of all resources for the specified scope. The response from this GET operation can be leveraged to submit requests to update a quota.
create_or_update	INSERT	resourceName, scope	Create or update the quota limit for the specified resource with the requested value. To update the quota, follow these steps:

1. Use the GET operation for quotas and usages to determine how much quota remains for the specific resource and to calculate the new quota limit. These steps are detailed in this example.
2. Use this PUT operation to update the quota limit. Please check the URI in location header for the detailed status of the request. | | update | UPDATE | resourceName, scope | Update the quota limit for a specific resource to the specified value:
3. Use the Usages-GET and Quota-GET operations to determine the remaining quota for the specific resource and to calculate the new quota limit. These steps are detailed in this example.
4. Use this PUT operation to update the quota limit. Please check the URI in location header for the detailed status of the request. |

SELECT examples

Get a list of current quota limits of all resources for the specified scope. The response from this GET operation can be leveraged to submit requests to update a quota.

vw_quotas

SELECT
id,
name,
is_quota_applicable,
limit,
properties,
quota_period,
resourceName,
resource_type,
scope,
type,
unit
FROM azure.quota.vw_quotas
WHERE scope = '{{ scope }}';

quotas

SELECT
id,
name,
properties,
type
FROM azure.quota.quotas
WHERE scope = '{{ scope }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.quota.quotas (
resourceName,
scope,
properties
)
SELECT 
'{{ resourceName }}',
'{{ scope }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: type
      value: string
    - name: name
      value: string
    - name: properties
      value:
        - name: limit
          value:
            - name: limitObjectType
              value: []
        - name: unit
          value: string
        - name: name
          value:
            - name: value
              value: string
            - name: localizedValue
              value: string
        - name: resourceType
          value: []
        - name: quotaPeriod
          value: string
        - name: isQuotaApplicable
          value: boolean
        - name: properties
          value: object

UPDATE example

Updates a quotas resource.

/*+ update */
UPDATE azure.quota.quotas
SET 
properties = '{{ properties }}'
WHERE 
resourceName = '{{ resourceName }}'
AND scope = '{{ scope }}';