Skip to main content

vw_brokers

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

Overview​

Namevw_brokers
TypeView
Idazure.iot_mq.vw_brokers

Fields​

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition​

SELECT
location as location,
extendedLocation as extended_location,
tags as tags,
JSON_EXTRACT(properties, '$.authImage') as "auth_image",
JSON_EXTRACT(properties, '$.brokerImage') as "broker_image",
JSON_EXTRACT(properties, '$.brokerNodeTolerations') as "broker_node_tolerations",
JSON_EXTRACT(properties, '$.cardinality') as "cardinality",
JSON_EXTRACT(properties, '$.diagnostics') as "diagnostics",
JSON_EXTRACT(properties, '$.diskBackedMessageBufferSettings') as "disk_backed_message_buffer_settings",
JSON_EXTRACT(properties, '$.encryptInternalTraffic') as "encrypt_internal_traffic",
JSON_EXTRACT(properties, '$.healthManagerImage') as "health_manager_image",
JSON_EXTRACT(properties, '$.healthManagerNodeTolerations') as "health_manager_node_tolerations",
JSON_EXTRACT(properties, '$.internalCerts') as "internal_certs",
JSON_EXTRACT(properties, '$.memoryProfile') as "memory_profile",
JSON_EXTRACT(properties, '$.mode') as "mode",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
subscriptionId,
resourceGroupName,
mqName,
brokerName
FROM azure.iot_mq.brokers
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND mqName = 'replace-me';