commitment_plans_plans

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

Overview

Name	commitment_plans_plans
Type	Resource
Id	azure.cognitive_services.commitment_plans_plans

Fields

vw_commitment_plans_plans

Name	Datatype	Description
auto_renew	text	field from the properties object
commitmentPlanName	text	field from the properties object
commitment_plan_guid	text	field from the properties object
current	text	field from the properties object
etag	text	Resource Etag.
hosting_model	text	field from the properties object
kind	text	The kind (type) of cognitive service account.
last	text	field from the properties object
location	text	The geo-location where the resource lives
next	text	field from the properties object
plan_type	text	field from the properties object
provisioning_issues	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
sku	text	The resource model definition representing SKU
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
tags	text	Resource tags.

commitment_plans_plans

Name	Datatype	Description
etag	string	Resource Etag.
kind	string	The kind (type) of cognitive service account.
location	string	The geo-location where the resource lives
properties	object	Properties of Cognitive Services account commitment plan.
sku	object	The resource model definition representing SKU
systemData	object	Metadata pertaining to creation and last modification of the resource.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	commitmentPlanName, resourceGroupName, subscriptionId	Returns a Cognitive Services commitment plan specified by the parameters.
create_or_update	INSERT	commitmentPlanName, resourceGroupName, subscriptionId	Create Cognitive Services commitment plan.
delete	DELETE	commitmentPlanName, resourceGroupName, subscriptionId	Deletes a Cognitive Services commitment plan from the resource group.
update	UPDATE	commitmentPlanName, resourceGroupName, subscriptionId	Create Cognitive Services commitment plan.

SELECT examples

Returns a Cognitive Services commitment plan specified by the parameters.

vw_commitment_plans_plans

SELECT
auto_renew,
commitmentPlanName,
commitment_plan_guid,
current,
etag,
hosting_model,
kind,
last,
location,
next,
plan_type,
provisioning_issues,
provisioning_state,
resourceGroupName,
sku,
subscriptionId,
system_data,
tags
FROM azure.cognitive_services.vw_commitment_plans_plans
WHERE commitmentPlanName = '{{ commitmentPlanName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

commitment_plans_plans

SELECT
etag,
kind,
location,
properties,
sku,
systemData,
tags
FROM azure.cognitive_services.commitment_plans_plans
WHERE commitmentPlanName = '{{ commitmentPlanName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.cognitive_services.commitment_plans_plans (
commitmentPlanName,
resourceGroupName,
subscriptionId,
kind,
sku,
tags,
location,
properties
)
SELECT 
'{{ commitmentPlanName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ kind }}',
'{{ sku }}',
'{{ tags }}',
'{{ location }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string
    - name: etag
      value: string
    - name: kind
      value: []
    - name: sku
      value:
        - name: name
          value: string
        - name: tier
          value: string
        - name: size
          value: string
        - name: family
          value: string
        - name: capacity
          value: integer
    - name: tags
      value: object
    - name: location
      value: string
    - name: properties
      value:
        - name: provisioningState
          value: string
        - name: commitmentPlanGuid
          value: string
        - name: hostingModel
          value: []
        - name: planType
          value: string
        - name: current
          value:
            - name: tier
              value: string
            - name: count
              value: integer
            - name: quota
              value:
                - name: quantity
                  value: integer
                - name: unit
                  value: string
            - name: startDate
              value: string
            - name: endDate
              value: string
        - name: autoRenew
          value: boolean
        - name: provisioningIssues
          value:
            - string

UPDATE example

Updates a commitment_plans_plans resource.

/*+ update */
UPDATE azure.cognitive_services.commitment_plans_plans
SET 
sku = '{{ sku }}',
tags = '{{ tags }}'
WHERE 
commitmentPlanName = '{{ commitmentPlanName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified commitment_plans_plans resource.

/*+ delete */
DELETE FROM azure.cognitive_services.commitment_plans_plans
WHERE commitmentPlanName = '{{ commitmentPlanName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';