publishers

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

Overview

Name	publishers
Type	Resource
Id	azure.hybrid_network.publishers

Fields

vw_publishers

Name	Datatype	Description
identity	text	Managed service identity (system assigned and/or user assigned identities)
location	text	The geo-location where the resource lives
provisioning_state	text	field from the properties object
publisherName	text	field from the properties object
resourceGroupName	text	field from the properties object
scope	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.

publishers

Name	Datatype	Description
identity	object	Managed service identity (system assigned and/or user assigned identities)
location	string	The geo-location where the resource lives
properties	object	publisher properties.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	publisherName, resourceGroupName, subscriptionId	Gets information about the specified publisher.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Lists all the publishers in a resource group.
list_by_subscription	SELECT	subscriptionId	Lists all the publishers in a subscription.
create_or_update	INSERT	publisherName, resourceGroupName, subscriptionId	Creates or updates a publisher.
delete	DELETE	publisherName, resourceGroupName, subscriptionId	Deletes the specified publisher.
update	UPDATE	publisherName, resourceGroupName, subscriptionId	Update a publisher resource.

SELECT examples

Lists all the publishers in a subscription.

vw_publishers

SELECT
identity,
location,
provisioning_state,
publisherName,
resourceGroupName,
scope,
subscriptionId,
tags
FROM azure.hybrid_network.vw_publishers
WHERE subscriptionId = '{{ subscriptionId }}';

publishers

SELECT
identity,
location,
properties,
tags
FROM azure.hybrid_network.publishers
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.hybrid_network.publishers (
publisherName,
resourceGroupName,
subscriptionId,
properties,
identity,
tags,
location
)
SELECT 
'{{ publisherName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ identity }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: provisioningState
          value: []
        - name: scope
          value: []
    - name: identity
      value:
        - name: principalId
          value: string
        - name: tenantId
          value: string
        - name: type
          value: []
        - name: userAssignedIdentities
          value: []
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a publishers resource.

/*+ update */
UPDATE azure.hybrid_network.publishers
SET 
tags = '{{ tags }}'
WHERE 
publisherName = '{{ publisherName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified publishers resource.

/*+ delete */
DELETE FROM azure.hybrid_network.publishers
WHERE publisherName = '{{ publisherName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';