steampipe plugin install azure

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;

Schema for azure_eventgrid_topic

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
cloud_environmenttextThe Azure Cloud Environment.
created_attimestamp with time zoneThe timestamp of resource creation (UTC).
created_bytextThe identity that created the resource.
created_by_typetextThe type of identity that created the resource.
diagnostic_settingsjsonbA list of active diagnostic settings for the eventgrid topic.
disable_local_authbooleanThis 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.
endpointtextEndpoint for the event grid topic resource which is used for publishing the events.
extended_locationjsonbExtended location of the resource.
idtextFully qualified identifier of the resource.
identityjsonbIdentity information for the resource.
inbound_ip_rulesjsonbThis can be used to restrict traffic from specific IPs instead of all IPs. Note: These are considered only if PublicNetworkAccess is enabled.
input_schematextThis 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_mappingjsonbInformation about the InputSchemaMapping which specified the info about mapping event payload.
kindtextKind of the resource.
last_modified_attimestamp with time zoneThe timestamp of resource last modification (UTC).
last_modified_bytextThe identity that last modified the resource.
last_modified_by_typetextThe type of identity that last modified the resource.
locationtextLocation of the resource.
nametext=The name of the resource.
private_endpoint_connectionsjsonbList of private endpoint connections for the event grid topic.
provisioning_statetextProvisioning state of the event grid topic resource. Possible values include: 'Creating', 'Updating', 'Deleting', 'Succeeded', 'Canceled', 'Failed'.
public_network_accesstextThis determines if traffic is allowed over public network. By default it is enabled.
regiontextThe Azure region/location in which the resource is located.
resource_grouptext=The resource group which holds this resource.
sku_nametextName of this SKU. Possible values include: 'Basic', 'Standard'.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
subscription_idtext=, !=, ~~, ~~*, !~~, !~~*The Azure Subscription ID in which the resource is located.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
typetextThe 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