Skip to main content

fabric_capacities

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

Overview

Namefabric_capacities
TypeResource
Idazure.fabric.fabric_capacities

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}. # pylint: disable=line-too-long
namestringThe name of the resource.
administrationobjectThe capacity administration. Required.
locationstringThe geo-location where the resource lives. Required.
provisioningStatestringThe current deployment state of Microsoft Fabric resource. The provisioningState is to indicate states for resource provisioning. Known values are: "Succeeded", "Failed", "Canceled", "Deleting", "Provisioning", and "Updating". (Succeeded, Failed, Canceled, Deleting, Provisioning, Updating)
skuobjectThe SKU details. Required.
statestringThe current state of Microsoft Fabric resource. The state is to indicate more states outside of resource provisioning. Known values are: "Active", "Provisioning", "Failed", "Updating", "Deleting", "Suspending", "Suspended", "Pausing", "Paused", "Resuming", "Scaling", and "Preparing". (Active, Provisioning, Failed, Updating, Deleting, Suspending, Suspended, Pausing, Paused, Resuming, Scaling, Preparing)
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
tagsobjectResource tags.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, capacity_name, subscription_idGet a FabricCapacity.
list_by_resource_groupselectresource_group_name, subscription_idList FabricCapacity resources by resource group.
check_name_availabilityselectlocation, subscription_idImplements local CheckNameAvailability operations.
list_by_subscriptionselectsubscription_idList FabricCapacity resources by subscription ID.
create_or_updateinsertresource_group_name, capacity_name, subscription_id, location, properties, skuCreate a FabricCapacity.
updateupdateresource_group_name, capacity_name, subscription_idUpdate a FabricCapacity.
create_or_updatereplaceresource_group_name, capacity_name, subscription_id, location, properties, skuCreate a FabricCapacity.
deletedeleteresource_group_name, capacity_name, subscription_idDelete a FabricCapacity.
list_skus_for_capacityexecresource_group_name, capacity_name, subscription_idList eligible SKUs for a Microsoft Fabric resource.
list_skusexecsubscription_idList eligible SKUs for Microsoft Fabric resource provider.
resumeexecresource_group_name, capacity_name, subscription_idResume operation of the specified Fabric capacity instance.
suspendexecresource_group_name, capacity_name, subscription_idSuspend 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
capacity_namestringThe name of the Microsoft Fabric capacity. It must be a minimum of 3 characters, and a maximum of 63. Required.
locationstringThe name of the Azure region. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring

SELECT examples

Get a FabricCapacity.

SELECT
id,
name,
administration,
location,
provisioningState,
sku,
state,
systemData,
tags,
type
FROM azure.fabric.fabric_capacities
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND capacity_name = '{{ capacity_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create a FabricCapacity.

INSERT INTO azure.fabric.fabric_capacities (
tags,
location,
properties,
sku,
resource_group_name,
capacity_name,
subscription_id
)
SELECT
'{{ tags }}',
'{{ location }}' /* required */,
'{{ properties }}' /* required */,
'{{ sku }}' /* required */,
'{{ resource_group_name }}',
'{{ capacity_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
location,
properties,
sku,
systemData,
tags,
type
;

UPDATE examples

Update a FabricCapacity.

UPDATE azure.fabric.fabric_capacities
SET
sku = '{{ sku }}',
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND capacity_name = '{{ capacity_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
location,
properties,
sku,
systemData,
tags,
type;

REPLACE examples

Create a FabricCapacity.

REPLACE azure.fabric.fabric_capacities
SET
tags = '{{ tags }}',
location = '{{ location }}',
properties = '{{ properties }}',
sku = '{{ sku }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND capacity_name = '{{ capacity_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND location = '{{ location }}' --required
AND properties = '{{ properties }}' --required
AND sku = '{{ sku }}' --required
RETURNING
id,
name,
location,
properties,
sku,
systemData,
tags,
type;

DELETE examples

Delete a FabricCapacity.

DELETE FROM azure.fabric.fabric_capacities
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND capacity_name = '{{ capacity_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;

Lifecycle Methods

List eligible SKUs for a Microsoft Fabric resource.

EXEC azure.fabric.fabric_capacities.list_skus_for_capacity 
@resource_group_name='{{ resource_group_name }}' --required,
@capacity_name='{{ capacity_name }}' --required,
@subscription_id='{{ subscription_id }}' --required
;