topics

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

Overview

Name	topics
Type	Resource
Id	azure.event_grid.topics

Fields

vw_topics

Name	Datatype	Description
data_residency_boundary	text	field from the properties object
disable_local_auth	text	field from the properties object
endpoint	text	field from the properties object
event_type_info	text	field from the properties object
extended_location	text	field from the properties object
identity	text	The identity information for the resource.
inbound_ip_rules	text	field from the properties object
input_schema	text	field from the properties object
input_schema_mapping	text	field from the properties object
kind	text	Kind of the resource.
location	text	The geo-location where the resource lives
metric_resource_id	text	field from the properties object
minimum_tls_version_allowed	text	field from the properties object
private_endpoint_connections	text	field from the properties object
provisioning_state	text	field from the properties object
public_network_access	text	field from the properties object
resourceGroupName	text	field from the properties object
sku	text	Describes an EventGrid Resource Sku.
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
tags	text	Resource tags.
topicName	text	field from the properties object

topics

Name	Datatype	Description
extendedLocation	object	Definition of an Extended Location
identity	object	The identity information for the resource.
kind	string	Kind of the resource.
location	string	The geo-location where the resource lives
properties	object	Properties of the Topic.
sku	object	Describes an EventGrid Resource Sku.
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, topicName	Get properties of a topic.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	List all the topics under a resource group.
list_by_subscription	SELECT	subscriptionId	List all the topics under an Azure subscription.
create_or_update	INSERT	resourceGroupName, subscriptionId, topicName	Asynchronously creates a new topic with the specified parameters.
delete	DELETE	resourceGroupName, subscriptionId, topicName	Delete existing topic.
update	UPDATE	resourceGroupName, subscriptionId, topicName	Asynchronously updates a topic with the specified parameters.
regenerate_key	EXEC	resourceGroupName, subscriptionId, topicName, data__keyName	Regenerate a shared access key for a topic.

SELECT examples

List all the topics under an Azure subscription.

vw_topics

SELECT
data_residency_boundary,
disable_local_auth,
endpoint,
event_type_info,
extended_location,
identity,
inbound_ip_rules,
input_schema,
input_schema_mapping,
kind,
location,
metric_resource_id,
minimum_tls_version_allowed,
private_endpoint_connections,
provisioning_state,
public_network_access,
resourceGroupName,
sku,
subscriptionId,
system_data,
tags,
topicName
FROM azure.event_grid.vw_topics
WHERE subscriptionId = '{{ subscriptionId }}';

topics

SELECT
extendedLocation,
identity,
kind,
location,
properties,
sku,
systemData,
tags
FROM azure.event_grid.topics
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.event_grid.topics (
resourceGroupName,
subscriptionId,
topicName,
tags,
location,
properties,
sku,
identity,
kind,
extendedLocation
)
SELECT 
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ topicName }}',
'{{ tags }}',
'{{ location }}',
'{{ properties }}',
'{{ sku }}',
'{{ identity }}',
'{{ kind }}',
'{{ extendedLocation }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: tags
      value: object
    - name: location
      value: string
    - name: properties
      value:
        - name: privateEndpointConnections
          value:
            - - name: id
                value: string
              - name: name
                value: string
              - name: type
                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: properties
                value:
                  - name: privateEndpoint
                    value:
                      - name: id
                        value: string
                  - name: groupIds
                    value:
                      - string
                  - name: privateLinkServiceConnectionState
                    value:
                      - name: status
                        value: string
                      - name: description
                        value: string
                      - name: actionsRequired
                        value: string
                  - name: provisioningState
                    value: string
        - name: provisioningState
          value: string
        - name: endpoint
          value: string
        - name: eventTypeInfo
          value:
            - name: kind
              value: string
            - name: inlineEventTypes
              value: object
        - name: minimumTlsVersionAllowed
          value: string
        - name: inputSchema
          value: string
        - name: inputSchemaMapping
          value:
            - name: inputSchemaMappingType
              value: string
        - name: metricResourceId
          value: string
        - name: publicNetworkAccess
          value: string
        - name: inboundIpRules
          value:
            - - name: ipMask
                value: string
              - name: action
                value: string
        - name: disableLocalAuth
          value: boolean
        - name: dataResidencyBoundary
          value: string
    - name: sku
      value:
        - name: name
          value: string
    - name: identity
      value:
        - name: type
          value: string
        - name: principalId
          value: string
        - name: tenantId
          value: string
        - name: userAssignedIdentities
          value: object
    - name: kind
      value: string
    - name: extendedLocation
      value:
        - name: name
          value: string
        - name: type
          value: string

UPDATE example

Updates a topics resource.

/*+ update */
UPDATE azure.event_grid.topics
SET 
tags = '{{ tags }}',
identity = '{{ identity }}',
properties = '{{ properties }}',
sku = '{{ sku }}'
WHERE 
resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND topicName = '{{ topicName }}';

DELETE example

Deletes the specified topics resource.

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