steampipe plugin install azuresteampipe plugin install azure
azure_ad_groupazure_ad_service_principalazure_ad_userazure_alert_managementazure_api_managementazure_api_management_backendazure_app_configurationazure_app_service_environmentazure_app_service_function_appazure_app_service_planazure_app_service_web_appazure_app_service_web_app_slotazure_application_gatewayazure_application_insightazure_application_security_groupazure_automation_accountazure_automation_variableazure_bastion_hostazure_batch_accountazure_cognitive_accountazure_compute_availability_setazure_compute_diskazure_compute_disk_accessazure_compute_disk_encryption_setazure_compute_disk_metric_read_opsazure_compute_disk_metric_read_ops_dailyazure_compute_disk_metric_read_ops_hourlyazure_compute_disk_metric_write_opsazure_compute_disk_metric_write_ops_dailyazure_compute_disk_metric_write_ops_hourlyazure_compute_imageazure_compute_resource_skuazure_compute_snapshotazure_compute_ssh_keyazure_compute_virtual_machineazure_compute_virtual_machine_metric_cpu_utilizationazure_compute_virtual_machine_metric_cpu_utilization_dailyazure_compute_virtual_machine_metric_cpu_utilization_hourlyazure_compute_virtual_machine_scale_setazure_compute_virtual_machine_scale_set_network_interfaceazure_compute_virtual_machine_scale_set_vmazure_consumption_usageazure_container_groupazure_container_registryazure_cosmosdb_accountazure_cosmosdb_mongo_collectionazure_cosmosdb_mongo_databaseazure_cosmosdb_restorable_database_accountazure_cosmosdb_sql_databaseazure_data_factoryazure_data_factory_datasetazure_data_factory_pipelineazure_data_lake_analytics_accountazure_data_lake_storeazure_databox_edge_deviceazure_databricks_workspaceazure_diagnostic_settingazure_dns_zoneazure_eventgrid_domainazure_eventgrid_topicazure_eventhub_namespaceazure_express_route_circuitazure_firewallazure_firewall_policyazure_frontdoorazure_hdinsight_clusterazure_healthcare_serviceazure_hpc_cacheazure_hybrid_compute_machineazure_hybrid_kubernetes_connected_clusterazure_iothubazure_iothub_dpsazure_key_vaultazure_key_vault_deleted_vaultazure_key_vault_keyazure_key_vault_key_versionazure_key_vault_managed_hardware_security_moduleazure_key_vault_secretazure_kubernetes_clusterazure_kubernetes_service_versionazure_kusto_clusterazure_lbazure_lb_backend_address_poolazure_lb_nat_ruleazure_lb_outbound_ruleazure_lb_probeazure_lb_ruleazure_locationazure_log_alertazure_log_profileazure_logic_app_workflowazure_machine_learning_workspaceazure_management_groupazure_management_lockazure_mariadb_serverazure_monitor_activity_log_eventazure_monitor_log_profileazure_mssql_elasticpoolazure_mssql_managed_instanceazure_mssql_virtual_machineazure_mysql_flexible_serverazure_mysql_serverazure_nat_gatewayazure_network_interfaceazure_network_security_groupazure_network_watcherazure_network_watcher_flow_logazure_policy_assignmentazure_policy_definitionazure_postgresql_flexible_serverazure_postgresql_serverazure_private_dns_zoneazure_providerazure_public_ipazure_recovery_services_backup_jobazure_recovery_services_vaultazure_redis_cacheazure_resource_groupazure_resource_linkazure_role_assignmentazure_role_definitionazure_route_tableazure_search_serviceazure_security_center_auto_provisioningazure_security_center_automationazure_security_center_contactazure_security_center_jit_network_access_policyazure_security_center_settingazure_security_center_sub_assessmentazure_security_center_subscription_pricingazure_service_fabric_clusterazure_servicebus_namespaceazure_signalr_serviceazure_spring_cloud_serviceazure_sql_databaseazure_sql_serverazure_storage_accountazure_storage_blobazure_storage_blob_serviceazure_storage_containerazure_storage_queueazure_storage_share_fileazure_storage_syncazure_storage_tableazure_storage_table_serviceazure_stream_analytics_jobazure_subnetazure_subscriptionazure_synapse_workspaceazure_tenantazure_virtual_networkazure_virtual_network_gateway

Table: azure_express_route_circuit - Query Azure Express Route Circuits using SQL

Azure Express Route Circuits is a dedicated connectivity option in Microsoft Azure that enables users to create private connections between Azure datacenters and infrastructure on their premises or in a colocation environment. It provides a more reliable, faster, and lower-latency network connection than typical internet-based connections. Express Route Circuits are highly beneficial for bandwidth-heavy tasks, data migration, and secure connectivity needs.

Table Usage Guide

The azure_express_route_circuit table provides insights into Express Route Circuits within Microsoft Azure. As a Network Administrator, explore circuit-specific details through this table, including peering information, service provider details, and bandwidth. Utilize it to monitor the performance and status of each Express Route Circuit, ensuring optimal connectivity and performance for your Azure resources.

Examples

Basic info

Explore the status and settings of your Azure Express Route Circuits to understand their operational capabilities and provisioning state. This can assist in managing and optimizing your network connectivity.

select
name,
id,
allow_classic_operations,
circuit_provisioning_state
from
azure_express_route_circuit;
select
name,
id,
allow_classic_operations,
circuit_provisioning_state
from
azure_express_route_circuit;

List express route circuits with global reach enabled

Explore the express route circuits in your Azure environment that have global reach enabled. This is useful for assessing the scale of your network connectivity and understanding the associated costs.

select
name,
sku_tier,
sku_name
from
azure_express_route_circuit
where
global_reach_enabled;
select
name,
sku_tier,
sku_name
from
azure_express_route_circuit
where
global_reach_enabled = 1;

List premium express route circuits

Explore which express route circuits in your Azure environment are categorized as 'Premium'. This can be useful for understanding your network infrastructure and identifying areas for potential cost optimization.

select
name,
sku_tier,
sku_name
from
azure_express_route_circuit
where
sku_tier = 'Premium';
select
name,
sku_tier,
sku_name
from
azure_express_route_circuit
where
sku_tier = 'Premium';

Query examples

Control examples

Schema for azure_express_route_circuit

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
allow_classic_operationsbooleanAllow classic operations.
authorizationsjsonbThe list of authorizations.
bandwidth_in_gbpsdouble precisionThe bandwidth of the circuit when the circuit is provisioned on an ExpressRoutePort resource.
circuit_provisioning_statetextThe CircuitProvisioningState state of the resource.
cloud_environmenttextThe Azure Cloud Environment.
etagtextAn unique read-only string that changes whenever the resource is updated.
express_route_portjsonbThe reference to the ExpressRoutePort resource when the circuit is provisioned on an ExpressRoutePort resource.
global_reach_enabledbooleanFlag denoting global reach status.
idtextResource ID.
nametext=The friendly name that identifies the circuit.
peeringsjsonbThe list of peerings.
provisioning_statetextThe provisioning state of the express route circuit resource. Possible values include: 'Succeeded', 'Updating', 'Deleting', 'Failed'.
regiontextThe Azure region/location in which the resource is located.
resource_grouptext=The resource group which holds this resource.
service_keytextThe ServiceKey.
service_provider_notestextThe ServiceProviderNotes.
service_provider_propertiesjsonbThe ServiceProviderProperties.
service_provider_provisioning_statetextThe ServiceProviderProvisioningState state of the resource. Possible values include: 'NotProvisioned', 'Provisioning', 'Provisioned', 'Deprovisioning'.
sku_familytextThe family of the SKU. Possible values include: 'UnlimitedData', 'MeteredData'.
sku_nametextThe name of the SKU.
sku_tiertextThe tier of the SKU. Possible values include: 'Standard', 'Premium', 'Basic', 'Local'.
subscription_idtextThe Azure Subscription ID in which the resource is located.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.

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_express_route_circuit