capacities

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

Overview

Name	capacities
Type	Resource
Id	azure.powerbi_dedicated.capacities

Fields

Name	Datatype	Description
id	string	An identifier that represents the PowerBI Dedicated resource.
name	string	The name of the PowerBI Dedicated resource.
location	string	Location of the PowerBI Dedicated resource.
properties	object	Properties of Dedicated Capacity resource.
sku	object	Represents the SKU name and Azure pricing tier for PowerBI Dedicated capacity resource.
systemData	object	Metadata pertaining to creation and last modification of the resource.
tags	object	Key-value pairs of additional resource provisioning properties.
type	string	The type of the PowerBI Dedicated resource.

Methods

Name	Accessible by	Required Params	Description
list	SELECT	subscriptionId	Lists all the Dedicated capacities for the given subscription.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Gets all the Dedicated capacities for the given resource group.
create	INSERT	dedicatedCapacityName, resourceGroupName, subscriptionId, data__sku	Provisions the specified Dedicated capacity based on the configuration specified in the request.
delete	DELETE	dedicatedCapacityName, resourceGroupName, subscriptionId	Deletes the specified Dedicated capacity.
update	UPDATE	dedicatedCapacityName, resourceGroupName, subscriptionId	Updates the current state of the specified Dedicated capacity.
check_name_availability	EXEC	location, subscriptionId	Check the name availability in the target location.
resume	EXEC	dedicatedCapacityName, resourceGroupName, subscriptionId	Resumes operation of the specified Dedicated capacity instance.
suspend	EXEC	dedicatedCapacityName, resourceGroupName, subscriptionId	Suspends operation of the specified dedicated capacity instance.

SELECT examples

Lists all the Dedicated capacities for the given subscription.

SELECT
id,
name,
location,
properties,
sku,
systemData,
tags,
type
FROM azure.powerbi_dedicated.capacities
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.powerbi_dedicated.capacities (
dedicatedCapacityName,
resourceGroupName,
subscriptionId,
data__sku,
sku,
properties,
location,
tags,
systemData
)
SELECT 
'{{ dedicatedCapacityName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__sku }}',
'{{ sku }}',
'{{ properties }}',
'{{ location }}',
'{{ tags }}',
'{{ systemData }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: sku
      value:
        - name: name
          value: string
        - name: tier
          value: string
        - name: capacity
          value: integer
    - name: properties
      value:
        - name: state
          value: string
        - name: provisioningState
          value: string
        - name: administration
          value:
            - name: members
              value:
                - string
        - name: mode
          value: string
        - name: tenantId
          value: string
        - name: friendlyName
          value: string
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: location
      value: string
    - name: tags
      value: object
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: []
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedAt
          value: string

UPDATE example

Updates a capacities resource.

/*+ update */
UPDATE azure.powerbi_dedicated.capacities
SET 
sku = '{{ sku }}',
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
dedicatedCapacityName = '{{ dedicatedCapacityName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified capacities resource.

/*+ delete */
DELETE FROM azure.powerbi_dedicated.capacities
WHERE dedicatedCapacityName = '{{ dedicatedCapacityName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';