vw_system_topic_event_subscriptions

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

Overview

Name	vw_system_topic_event_subscriptions
Type	View
Id	azure.event_grid.vw_system_topic_event_subscriptions

Fields

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

SQL Definition

Sqlite3

SELECT
id as id,
name as name,
type as type,
systemData as system_data,
JSON_EXTRACT(properties, '$.topic') as "topic",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.destination') as "destination",
JSON_EXTRACT(properties, '$.deliveryWithResourceIdentity') as "delivery_with_resource_identity",
JSON_EXTRACT(properties, '$.filter') as "filter",
JSON_EXTRACT(properties, '$.labels') as "labels",
JSON_EXTRACT(properties, '$.expirationTimeUtc') as "expiration_time_utc",
JSON_EXTRACT(properties, '$.eventDeliverySchema') as "event_delivery_schema",
JSON_EXTRACT(properties, '$.retryPolicy') as "retry_policy",
JSON_EXTRACT(properties, '$.deadLetterDestination') as "dead_letter_destination",
JSON_EXTRACT(properties, '$.deadLetterWithResourceIdentity') as "dead_letter_with_resource_identity",
subscriptionId,
resourceGroupName,
systemTopicName,
eventSubscriptionName
FROM azure.event_grid.system_topic_event_subscriptions
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND systemTopicName = 'replace-me';

Postgres

SELECT
id as id,
name as name,
type as type,
systemData as system_data,
json_extract_path_text(properties, '$.topic') as "topic",
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.destination') as "destination",
json_extract_path_text(properties, '$.deliveryWithResourceIdentity') as "delivery_with_resource_identity",
json_extract_path_text(properties, '$.filter') as "filter",
json_extract_path_text(properties, '$.labels') as "labels",
json_extract_path_text(properties, '$.expirationTimeUtc') as "expiration_time_utc",
json_extract_path_text(properties, '$.eventDeliverySchema') as "event_delivery_schema",
json_extract_path_text(properties, '$.retryPolicy') as "retry_policy",
json_extract_path_text(properties, '$.deadLetterDestination') as "dead_letter_destination",
json_extract_path_text(properties, '$.deadLetterWithResourceIdentity') as "dead_letter_with_resource_identity",
subscriptionId,
resourceGroupName,
systemTopicName,
eventSubscriptionName
FROM azure.event_grid.system_topic_event_subscriptions
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND systemTopicName = 'replace-me';