Skip to main content

queues

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

Overview

Namequeues
TypeResource
Idazure.storage.queues

Fields

The following fields are returned by SELECT queries:

OK -- returned table with the specified table name successfully.

NameDatatypeDescription
idstring (arm-id)Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
namestringThe name of the resource
propertiesobjectQueue resource properties. (x-ms-client-name: QueueProperties)
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
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
getselectresourceGroupName, accountName, subscriptionId, queueNameGets the queue with the specified queue name, under the specified account if it exists.
listselectresourceGroupName, accountName, subscriptionId$maxpagesize, $filterGets a list of all the queues under the specified storage account
createinsertresourceGroupName, accountName, subscriptionId, queueNameCreates a new queue with the specified queue name, under the specified account.
updateupdateresourceGroupName, accountName, subscriptionId, queueNameCreates a new queue with the specified queue name, under the specified account.
deletedeleteresourceGroupName, accountName, subscriptionId, queueNameDeletes the queue with the specified queue name, under the specified account if it exists.

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
accountNamestringThe name of the storage account within the specified resource group. Storage account names must be between 3 and 24 characters in length and use numbers and lower-case letters only.
queueNamestringA queue name must be unique within a storage account and must be between 3 and 63 characters.The name must comprise of lowercase alphanumeric and dash(-) characters only, it should begin and end with an alphanumeric character and it cannot have two consecutive dash(-) characters.
resourceGroupNamestringThe name of the resource group within the user's subscription. The name is case insensitive.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.
$filterstringOptional, When specified, only the queues with a name starting with the given filter will be listed.
$maxpagesizestringOptional, a maximum number of queues that should be included in a list queue response

SELECT examples

Gets the queue with the specified queue name, under the specified account if it exists.

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

INSERT examples

Creates a new queue with the specified queue name, under the specified account.

INSERT INTO azure.storage.queues (
data__properties,
resourceGroupName,
accountName,
subscriptionId,
queueName
)
SELECT
'{{ properties }}',
'{{ resourceGroupName }}',
'{{ accountName }}',
'{{ subscriptionId }}',
'{{ queueName }}'
RETURNING
id,
name,
properties,
systemData,
type
;

UPDATE examples

Creates a new queue with the specified queue name, under the specified account.

UPDATE azure.storage.queues
SET
data__properties = '{{ properties }}'
WHERE
resourceGroupName = '{{ resourceGroupName }}' --required
AND accountName = '{{ accountName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
AND queueName = '{{ queueName }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

DELETE examples

Deletes the queue with the specified queue name, under the specified account if it exists.

DELETE FROM azure.storage.queues
WHERE resourceGroupName = '{{ resourceGroupName }}' --required
AND accountName = '{{ accountName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
AND queueName = '{{ queueName }}' --required
;