Table: azure_eventgrid_topic - Query Azure Event Grid Topics using SQL

Azure Event Grid is a service within Microsoft Azure that enables the development of event-based applications and simplifies the creation of serverless workflows. It is a fully managed intelligent event routing service that uses a publish-subscribe model for uniform event consumption. Event Grid efficiently and reliably routes events from any source, to any destination, at any scale.

Table Usage Guide

The azure_eventgrid_topic table provides insights into Azure Event Grid Topics within Microsoft Azure. As a developer or system administrator, explore topic-specific details through this table, including event routing details, message retention policy, and associated metadata. Utilize it to uncover information about topics, such as those with specific event types, the routing policies, and the verification of event schemas.

Examples

Basic info

Gain insights into the status and details of your Azure EventGrid topics. This query is useful in monitoring the provisioning state and type of each topic, helping ensure smooth operation of your event-driven applications.

select
  name,
  id,
  type,
  provisioning_state
from
  azure_eventgrid_topic;

select
  name,
  id,
  type,
  provisioning_state
from
  azure_eventgrid_topic;

List domains not configured with private endpoint connections

Determine the areas in which domains are not set up with private endpoint connections. This can help in identifying potential security risks and ensuring all domains are properly configured.

select
  name,
  id,
  type,
  private_endpoint_connections
from
  azure_eventgrid_topic
where
  private_endpoint_connections is null;

select
  name,
  id,
  type,
  private_endpoint_connections
from
  azure_eventgrid_topic
where
  private_endpoint_connections is null;

List domains with local authentication disabled

Explore which domains have local authentication disabled to ensure high security. This is useful for identifying potential weak spots in your system's security configuration.

select
  name,
  id,
  type,
  disable_local_auth
from
  azure_eventgrid_topic
where
  disable_local_auth;

select
  name,
  id,
  type,
  disable_local_auth
from
  azure_eventgrid_topic
where
  disable_local_auth = 1;

Control examples

Schema for azure_eventgrid_topic

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
cloud_environment	text		The Azure Cloud Environment.
created_at	timestamp with time zone		The timestamp of resource creation (UTC).
created_by	text		The identity that created the resource.
created_by_type	text		The type of identity that created the resource.
diagnostic_settings	jsonb		A list of active diagnostic settings for the eventgrid topic.
disable_local_auth	boolean		This boolean is used to enable or disable local auth. Default value is false. When the property is set to true, only AAD token will be used to authenticate if user is allowed to publish to the topic.
endpoint	text		Endpoint for the event grid topic resource which is used for publishing the events.
extended_location	jsonb		Extended location of the resource.
id	text		Fully qualified identifier of the resource.
identity	jsonb		Identity information for the resource.
inbound_ip_rules	jsonb		This can be used to restrict traffic from specific IPs instead of all IPs. Note: These are considered only if PublicNetworkAccess is enabled.
input_schema	text		This determines the format that event grid should expect for incoming events published to the event grid topic resource. Possible values include: 'EventGridSchema', 'CustomEventSchema', 'CloudEventSchemaV10'.
input_schema_mapping	jsonb		Information about the InputSchemaMapping which specified the info about mapping event payload.
kind	text		Kind of the resource.
last_modified_at	timestamp with time zone		The timestamp of resource last modification (UTC).
last_modified_by	text		The identity that last modified the resource.
last_modified_by_type	text		The type of identity that last modified the resource.
location	text		Location of the resource.
name	text	=	The name of the resource.
private_endpoint_connections	jsonb		List of private endpoint connections for the event grid topic.
provisioning_state	text		Provisioning state of the event grid topic resource. Possible values include: 'Creating', 'Updating', 'Deleting', 'Succeeded', 'Canceled', 'Failed'.
public_network_access	text		This determines if traffic is allowed over public network. By default it is enabled.
region	text		The Azure region/location in which the resource is located.
resource_group	text	=	The resource group which holds this resource.
sku_name	text		Name of this SKU. Possible values include: 'Basic', 'Standard'.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
subscription_id	text	=, !=, ~~, ~~, !~~, !~~	The Azure Subscription ID in which the resource is located.
tags	jsonb		A map of tags for the resource.
title	text		Title of the resource.
type	text		The resource type.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- azure

You can pass the configuration to the command with the --config argument:

steampipe_export_azure --config '<your_config>' azure_eventgrid_topic