auto_scale_vcores

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

Overview

Name	auto_scale_vcores
Type	Resource
Id	azure.powerbi_dedicated.auto_scale_vcores

Fields

vw_auto_scale_vcores

Name	Datatype	Description
id	text	An identifier that represents the PowerBI Dedicated resource.
name	text	The name of the PowerBI Dedicated resource.
capacity_limit	text	field from the properties object
capacity_object_id	text	field from the properties object
location	text	Location of the PowerBI Dedicated resource.
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 auto scale v-core resource.
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
tags	text	Key-value pairs of additional resource provisioning properties.
type	text	The type of the PowerBI Dedicated resource.
vcoreName	text	field from the properties object

auto_scale_vcores

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 an auto scale v-core resource.
sku	object	Represents the SKU name and Azure pricing tier for auto scale v-core 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
get	SELECT	resourceGroupName, subscriptionId, vcoreName	Gets details about the specified auto scale v-core.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Gets all the auto scale v-cores for the given resource group.
list_by_subscription	SELECT	subscriptionId	Lists all the auto scale v-cores for the given subscription.
create	INSERT	resourceGroupName, subscriptionId, vcoreName, data__sku	Provisions the specified auto scale v-core based on the configuration specified in the request.
delete	DELETE	resourceGroupName, subscriptionId, vcoreName	Deletes the specified auto scale v-core.
update	UPDATE	resourceGroupName, subscriptionId, vcoreName	Updates the current state of the specified auto scale v-core.

SELECT examples

Lists all the auto scale v-cores for the given subscription.

vw_auto_scale_vcores

SELECT
id,
name,
capacity_limit,
capacity_object_id,
location,
provisioning_state,
resourceGroupName,
sku,
subscriptionId,
system_data,
tags,
type,
vcoreName
FROM azure.powerbi_dedicated.vw_auto_scale_vcores
WHERE subscriptionId = '{{ subscriptionId }}';

auto_scale_vcores

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

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.powerbi_dedicated.auto_scale_vcores (
resourceGroupName,
subscriptionId,
vcoreName,
data__sku,
sku,
properties,
location,
tags,
systemData
)
SELECT 
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ vcoreName }}',
'{{ 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: capacityObjectId
          value: string
        - name: provisioningState
          value: string
        - name: capacityLimit
          value: integer
    - 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 auto_scale_vcores resource.

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

DELETE example

Deletes the specified auto_scale_vcores resource.

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