Skip to main content

brokers

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

Overview

Namebrokers
TypeResource
Idazure.iot_mq.brokers

Fields

NameDatatypeDescription
auth_imagetextfield from the properties object
brokerNametextfield from the properties object
broker_imagetextfield from the properties object
broker_node_tolerationstextfield from the properties object
cardinalitytextfield from the properties object
diagnosticstextfield from the properties object
disk_backed_message_buffer_settingstextfield from the properties object
encrypt_internal_traffictextfield from the properties object
extended_locationtextfield from the properties object
health_manager_imagetextfield from the properties object
health_manager_node_tolerationstextfield from the properties object
internal_certstextfield from the properties object
locationtextThe geo-location where the resource lives
memory_profiletextfield from the properties object
modetextfield from the properties object
mqNametextfield from the properties object
provisioning_statetextfield from the properties object
resourceGroupNametextfield from the properties object
subscriptionIdtextfield from the properties object
tagstextResource tags.

Methods

NameAccessible byRequired ParamsDescription
getSELECTbrokerName, mqName, resourceGroupName, subscriptionIdGet a BrokerResource
list_by_mq_resourceSELECTmqName, resourceGroupName, subscriptionIdList BrokerResource resources by MqResource
create_or_updateINSERTbrokerName, mqName, resourceGroupName, subscriptionId, data__extendedLocationCreate a BrokerResource
deleteDELETEbrokerName, mqName, resourceGroupName, subscriptionIdDelete a BrokerResource
updateUPDATEbrokerName, mqName, resourceGroupName, subscriptionIdUpdate a BrokerResource

SELECT examples

List BrokerResource resources by MqResource

SELECT
auth_image,
brokerName,
broker_image,
broker_node_tolerations,
cardinality,
diagnostics,
disk_backed_message_buffer_settings,
encrypt_internal_traffic,
extended_location,
health_manager_image,
health_manager_node_tolerations,
internal_certs,
location,
memory_profile,
mode,
mqName,
provisioning_state,
resourceGroupName,
subscriptionId,
tags
FROM azure.iot_mq.vw_brokers
WHERE mqName = '{{ mqName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

/*+ create */
INSERT INTO azure.iot_mq.brokers (
brokerName,
mqName,
resourceGroupName,
subscriptionId,
data__extendedLocation,
properties,
extendedLocation,
tags,
location
)
SELECT
'{{ brokerName }}',
'{{ mqName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__extendedLocation }}',
'{{ properties }}',
'{{ extendedLocation }}',
'{{ tags }}',
'{{ location }}'
;

UPDATE example

Updates a brokers resource.

/*+ update */
UPDATE azure.iot_mq.brokers
SET
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE
brokerName = '{{ brokerName }}'
AND mqName = '{{ mqName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified brokers resource.

/*+ delete */
DELETE FROM azure.iot_mq.brokers
WHERE brokerName = '{{ brokerName }}'
AND mqName = '{{ mqName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';