capacities

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

Overview

Name	capacities
Type	Resource
Id	azure.fabric.capacities

Fields

vw_capacities

Name	Datatype	Description
administration	text	field from the properties object
capacityName	text	field from the properties object
location	text	The geo-location where the resource lives
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
sku	text	Represents the SKU name and Azure pricing tier for Microsoft Fabric capacity resource.
state	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.

capacities

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	The Microsoft Fabric capacity properties.
sku	object	Represents the SKU name and Azure pricing tier for Microsoft Fabric capacity resource.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	capacityName, resourceGroupName, subscriptionId	Get a FabricCapacity
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	List FabricCapacity resources by resource group
list_by_subscription	SELECT	subscriptionId	List FabricCapacity resources by subscription ID
create_or_update	INSERT	capacityName, resourceGroupName, subscriptionId, data__properties, data__sku	Create a FabricCapacity
delete	DELETE	capacityName, resourceGroupName, subscriptionId	Delete a FabricCapacity
update	UPDATE	capacityName, resourceGroupName, subscriptionId	Update a FabricCapacity
check_name_availability	EXEC	location, subscriptionId	Implements local CheckNameAvailability operations
resume	EXEC	capacityName, resourceGroupName, subscriptionId	Resume operation of the specified Fabric capacity instance.
suspend	EXEC	capacityName, resourceGroupName, subscriptionId	Suspend operation of the specified Fabric capacity instance.

SELECT examples

List FabricCapacity resources by subscription ID

vw_capacities

SELECT
administration,
capacityName,
location,
provisioning_state,
resourceGroupName,
sku,
state,
subscriptionId,
tags
FROM azure.fabric.vw_capacities
WHERE subscriptionId = '{{ subscriptionId }}';

capacities

SELECT
location,
properties,
sku,
tags
FROM azure.fabric.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.fabric.capacities (
capacityName,
resourceGroupName,
subscriptionId,
data__properties,
data__sku,
properties,
sku,
tags,
location
)
SELECT 
'{{ capacityName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ data__sku }}',
'{{ properties }}',
'{{ sku }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: provisioningState
          value: []
        - name: state
          value: []
        - name: administration
          value:
            - name: members
              value:
                - string
    - name: sku
      value:
        - name: name
          value: string
        - name: tier
          value: []
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a capacities resource.

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

DELETE example

Deletes the specified capacities resource.

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