Skip to main content

brokers

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

Overview

Namebrokers
TypeResource
Idazure.iot_mq.brokers

Fields

The following fields are returned by SELECT queries:

Azure operation completed successfully.

NameDatatypeDescription
extendedLocationobjectExtended Location
locationstringThe geo-location where the resource lives
propertiesobjectThe resource-specific properties for this resource.
tagsobjectResource tags.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, mqName, brokerNameGet a BrokerResource
list_by_mq_resourceselectsubscriptionId, resourceGroupName, mqNameList BrokerResource resources by MqResource
create_or_updateinsertsubscriptionId, resourceGroupName, mqName, brokerName, data__extendedLocationCreate a BrokerResource
updateupdatesubscriptionId, resourceGroupName, mqName, brokerNameUpdate a BrokerResource
deletedeletesubscriptionId, resourceGroupName, mqName, brokerNameDelete a BrokerResource

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
brokerNamestringName of MQ broker resource
mqNamestringName of MQ resource
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstringThe ID of the target subscription.

SELECT examples

Get a BrokerResource

SELECT
extendedLocation,
location,
properties,
tags
FROM azure.iot_mq.brokers
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND mqName = '{{ mqName }}' -- required
AND brokerName = '{{ brokerName }}' -- required
;

INSERT examples

Create a BrokerResource

INSERT INTO azure.iot_mq.brokers (
data__properties,
data__extendedLocation,
data__tags,
data__location,
subscriptionId,
resourceGroupName,
mqName,
brokerName
)
SELECT
'{{ properties }}',
'{{ extendedLocation }}' /* required */,
'{{ tags }}',
'{{ location }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ mqName }}',
'{{ brokerName }}'
RETURNING
extendedLocation,
location,
properties,
tags
;

UPDATE examples

Update a BrokerResource

UPDATE azure.iot_mq.brokers
SET
data__tags = '{{ tags }}',
data__properties = '{{ properties }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND mqName = '{{ mqName }}' --required
AND brokerName = '{{ brokerName }}' --required
RETURNING
extendedLocation,
location,
properties,
tags;

DELETE examples

Delete a BrokerResource

DELETE FROM azure.iot_mq.brokers
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND mqName = '{{ mqName }}' --required
AND brokerName = '{{ brokerName }}' --required
;