Skip to main content

capacities

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

Overview

Namecapacities
TypeResource
Idazure.fabric.capacities

Fields

The following fields are returned by SELECT queries:

Azure operation completed successfully.

NameDatatypeDescription
locationstringThe geo-location where the resource lives
propertiesobjectThe resource-specific properties for this resource.
skuobjectThe SKU details
tagsobjectResource tags.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, capacityNameGet a FabricCapacity
list_by_resource_groupselectsubscriptionId, resourceGroupNameList FabricCapacity resources by resource group
list_by_subscriptionselectsubscriptionIdList FabricCapacity resources by subscription ID
create_or_updateinsertsubscriptionId, resourceGroupName, capacityName, data__properties, data__skuCreate a FabricCapacity
updateupdatesubscriptionId, resourceGroupName, capacityNameUpdate a FabricCapacity
deletedeletesubscriptionId, resourceGroupName, capacityNameDelete a FabricCapacity
check_name_availabilityexecsubscriptionId, locationImplements local CheckNameAvailability operations
resumeexecsubscriptionId, resourceGroupName, capacityNameResume operation of the specified Fabric capacity instance.
suspendexecsubscriptionId, resourceGroupName, capacityNameSuspend operation of the specified Fabric capacity instance.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
capacityNamestringThe name of the Microsoft Fabric capacity. It must be a minimum of 3 characters, and a maximum of 63.
locationstringThe name of the Azure region.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.

SELECT examples

Get a FabricCapacity

SELECT
location,
properties,
sku,
tags
FROM azure.fabric.capacities
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND capacityName = '{{ capacityName }}' -- required
;

INSERT examples

Create a FabricCapacity

INSERT INTO azure.fabric.capacities (
data__properties,
data__sku,
data__tags,
data__location,
subscriptionId,
resourceGroupName,
capacityName
)
SELECT
'{{ properties }}' /* required */,
'{{ sku }}' /* required */,
'{{ tags }}',
'{{ location }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ capacityName }}'
RETURNING
location,
properties,
sku,
tags
;

UPDATE examples

Update a FabricCapacity

UPDATE azure.fabric.capacities
SET
data__sku = '{{ sku }}',
data__tags = '{{ tags }}',
data__properties = '{{ properties }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND capacityName = '{{ capacityName }}' --required
RETURNING
location,
properties,
sku,
tags;

DELETE examples

Delete a FabricCapacity

DELETE FROM azure.fabric.capacities
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND capacityName = '{{ capacityName }}' --required
;

Lifecycle Methods

Implements local CheckNameAvailability operations

EXEC azure.fabric.capacities.check_name_availability 
@subscriptionId='{{ subscriptionId }}' --required,
@location='{{ location }}' --required
@@json=
'{
"name": "{{ name }}",
"type": "{{ type }}"
}'
;