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;

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