broker_authorizations

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

Overview

Name	broker_authorizations
Type	Resource
Id	azure.iot_mq.broker_authorizations

Fields

vw_broker_authorizations

Name	Datatype	Description
authorizationName	text	field from the properties object
authorization_policies	text	field from the properties object
brokerName	text	field from the properties object
extended_location	text	field from the properties object
listener_ref	text	field from the properties object
location	text	The geo-location where the resource lives
mqName	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.

broker_authorizations

Name	Datatype	Description
extendedLocation	object	ExtendedLocation properties
location	string	The geo-location where the resource lives
properties	object	Broker Resource properties
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	authorizationName, brokerName, mqName, resourceGroupName, subscriptionId	Get a BrokerAuthorizationResource
list_by_broker_resource	SELECT	brokerName, mqName, resourceGroupName, subscriptionId	List BrokerAuthorizationResource resources by BrokerResource
create_or_update	INSERT	authorizationName, brokerName, mqName, resourceGroupName, subscriptionId, data__extendedLocation	Create a BrokerAuthorizationResource
delete	DELETE	authorizationName, brokerName, mqName, resourceGroupName, subscriptionId	Delete a BrokerAuthorizationResource
update	UPDATE	authorizationName, brokerName, mqName, resourceGroupName, subscriptionId	Update a BrokerAuthorizationResource

SELECT examples

List BrokerAuthorizationResource resources by BrokerResource

vw_broker_authorizations

SELECT
authorizationName,
authorization_policies,
brokerName,
extended_location,
listener_ref,
location,
mqName,
provisioning_state,
resourceGroupName,
subscriptionId,
tags
FROM azure.iot_mq.vw_broker_authorizations
WHERE brokerName = '{{ brokerName }}'
AND mqName = '{{ mqName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

broker_authorizations

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

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: authorizationPolicies
          value:
            - name: enableCache
              value: boolean
            - name: rules
              value:
                - - name: brokerResources
                    value:
                      - - name: method
                          value: []
                        - name: topics
                          value:
                            - string
                  - name: principals
                    value:
                      - name: attributes
                        value:
                          - object
                      - name: clientids
                        value:
                          - string
                      - name: usernames
                        value:
                          - string
        - name: listenerRef
          value:
            - string
        - name: provisioningState
          value: []
    - name: extendedLocation
      value:
        - name: name
          value: string
        - name: type
          value: []
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a broker_authorizations resource.

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

DELETE example

Deletes the specified broker_authorizations resource.

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