environments_worker_pools

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

Overview

Name	environments_worker_pools
Type	Resource
Id	azure.app_service.environments_worker_pools

Fields

vw_environments_worker_pools

Name	Datatype	Description
id	text	Resource Id.
name	text	Resource Name.
compute_mode	text	field from the properties object
instance_names	text	field from the properties object
kind	text	Kind of resource.
resourceGroupName	text	field from the properties object
sku	text	Description of a SKU for a scalable resource.
subscriptionId	text	field from the properties object
type	text	Resource type.
workerPoolName	text	field from the properties object
worker_count	text	field from the properties object
worker_size	text	field from the properties object
worker_size_id	text	field from the properties object

environments_worker_pools

Name	Datatype	Description
id	string	Resource Id.
name	string	Resource Name.
kind	string	Kind of resource.
properties	object	Worker pool of an App Service Environment.
sku	object	Description of a SKU for a scalable resource.
type	string	Resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	name, resourceGroupName, subscriptionId, workerPoolName	Description for Get properties of a worker pool.
list	SELECT	name, resourceGroupName, subscriptionId	Description for Get all worker pools of an App Service Environment.
create_or_update	INSERT	name, resourceGroupName, subscriptionId, workerPoolName	Description for Create or update a worker pool.
update	UPDATE	name, resourceGroupName, subscriptionId, workerPoolName	Description for Create or update a worker pool.

SELECT examples

Description for Get all worker pools of an App Service Environment.

vw_environments_worker_pools

SELECT
id,
name,
compute_mode,
instance_names,
kind,
resourceGroupName,
sku,
subscriptionId,
type,
workerPoolName,
worker_count,
worker_size,
worker_size_id
FROM azure.app_service.vw_environments_worker_pools
WHERE name = '{{ name }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

environments_worker_pools

SELECT
id,
name,
kind,
properties,
sku,
type
FROM azure.app_service.environments_worker_pools
WHERE name = '{{ name }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.app_service.environments_worker_pools (
name,
resourceGroupName,
subscriptionId,
workerPoolName,
kind,
properties,
sku
)
SELECT 
'{{ name }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ workerPoolName }}',
'{{ kind }}',
'{{ properties }}',
'{{ sku }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: kind
      value: string
    - name: type
      value: string
    - name: properties
      value:
        - name: workerSizeId
          value: integer
        - name: computeMode
          value: string
        - name: workerSize
          value: string
        - name: workerCount
          value: integer
        - name: instanceNames
          value:
            - string
    - name: sku
      value:
        - name: name
          value: string
        - name: tier
          value: string
        - name: size
          value: string
        - name: family
          value: string
        - name: capacity
          value: integer
        - name: skuCapacity
          value:
            - name: minimum
              value: integer
            - name: maximum
              value: integer
            - name: elasticMaximum
              value: integer
            - name: default
              value: integer
            - name: scaleType
              value: string
        - name: locations
          value:
            - string
        - name: capabilities
          value:
            - - name: name
                value: string
              - name: value
                value: string
              - name: reason
                value: string

UPDATE example

Updates a environments_worker_pools resource.

/*+ update */
UPDATE azure.app_service.environments_worker_pools
SET 
kind = '{{ kind }}',
properties = '{{ properties }}',
sku = '{{ sku }}'
WHERE 
name = '{{ name }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workerPoolName = '{{ workerPoolName }}';