steampipe plugin install azure

Table: azure_eventhub_namespace - Query Azure Event Hubs Namespaces using SQL

Azure Event Hubs is a big data streaming platform and event ingestion service. It can receive and process millions of events per second. A namespace is a scoping container for Event Hubs under an Azure subscription.

Table Usage Guide

The azure_eventhub_namespace table provides insights into Azure Event Hubs Namespaces. As a Data Engineer, you can explore namespace-specific details through this table, including its name, region, resource group, SKU, and more. Utilize it to manage and monitor the health and performance of your Azure Event Hubs Namespaces.

Examples

Basic info

Discover the segments that provide you with a comprehensive overview of your Azure EventHub namespaces. This includes details like the provisioning status and creation date, which can help you track and manage your resources more effectively.

select
name,
id,
type,
provisioning_state,
created_at
from
azure_eventhub_namespace;
select
name,
id,
type,
provisioning_state,
created_at
from
azure_eventhub_namespace;

List namespaces not configured to use virtual network service endpoint

Determine the areas in which Azure EventHub namespaces are not utilizing the virtual network service endpoint. This query is beneficial in identifying potential security loopholes, as these namespaces might be exposed to risks without the added protection of a virtual network.

select
name,
id,
type,
network_rule_set -> 'properties' -> 'virtualNetworkRules' as virtual_network_rules
from
azure_eventhub_namespace
where
network_rule_set -> 'properties' -> 'virtualNetworkRules' = '[]';
select
name,
id,
type,
json_extract(
network_rule_set,
'$.properties.virtualNetworkRules'
) as virtual_network_rules
from
azure_eventhub_namespace
where
json_extract(
network_rule_set,
'$.properties.virtualNetworkRules'
) = '[]';

List unencrypted namespaces

Discover the segments that are unencrypted within the Azure EventHub namespace. This is useful for identifying potential security vulnerabilities where sensitive data might not be adequately protected.

select
name,
id,
type,
encryption
from
azure_eventhub_namespace
where
encryption is null;
select
name,
id,
type,
encryption
from
azure_eventhub_namespace
where
encryption is null;

List namespaces with auto-inflate disabled

Identify the Azure EventHub namespaces where the auto-inflate feature is turned off. This can be useful to pinpoint potential resource limitations or throttling issues in your Azure EventHub service.

select
name,
id,
type,
is_auto_inflate_enabled
from
azure_eventhub_namespace
where
not is_auto_inflate_enabled;
select
name,
id,
type,
is_auto_inflate_enabled
from
azure_eventhub_namespace
where
not is_auto_inflate_enabled;

List private endpoint connection details

Determine the details of private endpoint connections within your Azure EventHub Namespace. This can help understand the state and type of connections, which is useful for managing and troubleshooting your network connectivity.

select
name,
id,
connections ->> 'id' as connection_id,
connections ->> 'name' as connection_name,
connections ->> 'privateEndpointPropertyID' as property_private_endpoint_id,
connections ->> 'provisioningState' as property_provisioning_state,
jsonb_pretty(connections -> 'privateLinkServiceConnectionState') as property_private_link_service_connection_state,
connections ->> 'type' as connection_type
from
azure_eventhub_namespace,
jsonb_array_elements(private_endpoint_connections) as connections;
select
name,
n.id,
json_extract(connections.value, '$.id') as connection_id,
json_extract(connections.value, '$.name') as connection_name,
json_extract(connections.value, '$.privateEndpointPropertyID') as property_private_endpoint_id,
json_extract(connections.value, '$.provisioningState') as property_provisioning_state,
connections.value as property_private_link_service_connection_state,
json_extract(connections.value, '$.type') as connection_type
from
azure_eventhub_namespace as n,
json_each(private_endpoint_connections) as connections;

Schema for azure_eventhub_namespace

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
cloud_environmenttextThe Azure Cloud Environment.
cluster_arm_idtextCluster ARM ID of the namespace.
created_attimestamp with time zoneThe time the namespace was created.
diagnostic_settingsjsonbA list of active diagnostic settings for the eventhub namespace.
encryptionjsonbProperties of BYOK encryption description.
idtextThe ID of the resource.
identityjsonbDescribes the properties of BYOK encryption description.
is_auto_inflate_enabledbooleanIndicates whether auto-inflate is enabled for eventhub namespace.
kafka_enabledbooleanIndicates whether kafka is enabled for eventhub namespace, or not.
maximum_throughput_unitsbigintUpper limit of throughput units when auto-inflate is enabled, value should be within 0 to 20 throughput units.
metric_idtextIdentifier for azure insights metrics.
nametext=The name of the resource.
network_rule_setjsonbDescribes the network rule set for specified namespace. The EventHub Namespace must be Premium in order to attach a EventHub Namespace Network Rule Set.
private_endpoint_connectionsjsonbThe private endpoint connections of the namespace.
provisioning_statetextProvisioning state of the namespace.
regiontextThe Azure region/location in which the resource is located.
resource_grouptext=The resource group which holds this resource.
service_bus_endpointtextEndpoint you can use to perform service bus operations.
sku_capacitybigintThe Event Hubs throughput units, value should be 0 to 20 throughput units.
sku_nametextName of this SKU. Possible values include: 'Basic', 'Standard'.
sku_tiertextThe billing tier of this particular SKU. Valid values are: 'Basic', 'Standard', 'Premium'.
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.
updated_attimestamp with time zoneThe time the namespace was updated.
zone_redundantbooleanEnabling this property creates a standard event hubs namespace in regions supported availability zones.

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_eventhub_namespace