queues

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

Overview

Name	queues
Type	Resource
Id	azure.storage.queues

Fields

vw_queues

Name	Datatype	Description
id	text	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
name	text	The name of the resource
accountName	text	field from the properties object
approximate_message_count	text	field from the properties object
metadata	text	field from the properties object
queueName	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
type	text	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

queues

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
name	string	The name of the resource
properties	object
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accountName, queueName, resourceGroupName, subscriptionId	Gets the queue with the specified queue name, under the specified account if it exists.
list	SELECT	accountName, resourceGroupName, subscriptionId	Gets a list of all the queues under the specified storage account
create	INSERT	accountName, queueName, resourceGroupName, subscriptionId	Creates a new queue with the specified queue name, under the specified account.
delete	DELETE	accountName, queueName, resourceGroupName, subscriptionId	Deletes the queue with the specified queue name, under the specified account if it exists.
update	UPDATE	accountName, queueName, resourceGroupName, subscriptionId	Creates a new queue with the specified queue name, under the specified account.

SELECT examples

Gets a list of all the queues under the specified storage account

vw_queues

SELECT
id,
name,
accountName,
approximate_message_count,
metadata,
queueName,
resourceGroupName,
subscriptionId,
type
FROM azure.storage.vw_queues
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

queues

SELECT
id,
name,
properties,
type
FROM azure.storage.queues
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.storage.queues (
accountName,
queueName,
resourceGroupName,
subscriptionId,
properties
)
SELECT 
'{{ accountName }}',
'{{ queueName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: metadata
          value: object
        - name: approximateMessageCount
          value: integer
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string

UPDATE example

Updates a queues resource.

/*+ update */
UPDATE azure.storage.queues
SET 
properties = '{{ properties }}'
WHERE 
accountName = '{{ accountName }}'
AND queueName = '{{ queueName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified queues resource.

/*+ delete */
DELETE FROM azure.storage.queues
WHERE accountName = '{{ accountName }}'
AND queueName = '{{ queueName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';