system_topics

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

Overview

Name	system_topics
Type	Resource
Id	azure.event_grid.system_topics

Fields

vw_system_topics

Name	Datatype	Description
identity	text	The identity information for the resource.
location	text	The geo-location where the resource lives
metric_resource_id	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
source	text	field from the properties object
subscriptionId	text	field from the properties object
systemTopicName	text	field from the properties object
system_data	text	field from the properties object
tags	text	Resource tags.
topic_type	text	field from the properties object

system_topics

Name	Datatype	Description
identity	object	The identity information for the resource.
location	string	The geo-location where the resource lives
properties	object	Properties of the System Topic.
systemData	object	Metadata pertaining to creation and last modification of the resource.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, subscriptionId, systemTopicName	Get properties of a system topic.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	List all the system topics under a resource group.
list_by_subscription	SELECT	subscriptionId	List all the system topics under an Azure subscription.
create_or_update	INSERT	resourceGroupName, subscriptionId, systemTopicName	Asynchronously creates a new system topic with the specified parameters.
delete	DELETE	resourceGroupName, subscriptionId, systemTopicName	Delete existing system topic.
update	UPDATE	resourceGroupName, subscriptionId, systemTopicName	Asynchronously updates a system topic with the specified parameters.

SELECT examples

List all the system topics under an Azure subscription.

vw_system_topics

SELECT
identity,
location,
metric_resource_id,
provisioning_state,
resourceGroupName,
source,
subscriptionId,
systemTopicName,
system_data,
tags,
topic_type
FROM azure.event_grid.vw_system_topics
WHERE subscriptionId = '{{ subscriptionId }}';

system_topics

SELECT
identity,
location,
properties,
systemData,
tags
FROM azure.event_grid.system_topics
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.event_grid.system_topics (
resourceGroupName,
subscriptionId,
systemTopicName,
tags,
location,
properties,
identity
)
SELECT 
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ systemTopicName }}',
'{{ tags }}',
'{{ location }}',
'{{ properties }}',
'{{ identity }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: tags
      value: object
    - name: location
      value: string
    - name: properties
      value:
        - name: provisioningState
          value: string
        - name: source
          value: string
        - name: topicType
          value: string
        - name: metricResourceId
          value: string
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string
    - name: identity
      value:
        - name: type
          value: string
        - name: principalId
          value: string
        - name: tenantId
          value: string
        - name: userAssignedIdentities
          value: object

UPDATE example

Updates a system_topics resource.

/*+ update */
UPDATE azure.event_grid.system_topics
SET 
tags = '{{ tags }}',
identity = '{{ identity }}'
WHERE 
resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND systemTopicName = '{{ systemTopicName }}';

DELETE example

Deletes the specified system_topics resource.

/*+ delete */
DELETE FROM azure.event_grid.system_topics
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND systemTopicName = '{{ systemTopicName }}';