steampipe plugin install azure

Table: azure_location - Query Azure Locations using SQL

Azure Locations represent the geographical data centers where Azure resources are hosted. They are spread across the globe, enabling users to deploy resources near their customers to reduce latency and improve application performance. Each location is made up of one or more data centers equipped with server, storage, and networking hardware.

Table Usage Guide

The azure_location table provides insights into the geographical locations within the Azure platform. As a cloud administrator or architect, explore location-specific details through this table, including name, regional display name, and longitude/latitude coordinates. Utilize it to plan your resource deployment strategy, ensuring optimal performance and compliance with data residency regulations.

Examples

Display name of each azure location

Explore which Azure locations are available by displaying their names. This is beneficial for understanding your geographic distribution options within the Azure platform.

select
name,
display_name
from
azure_location;
select
name,
display_name
from
azure_location;

Latitude and Longitude of the azure locations

Determine the geographical coordinates of various Azure locations. This is useful for mapping out data centers or planning for geo-redundancy.

select
name,
latitude,
longitude
from
azure_location;
select
name,
latitude,
longitude
from
azure_location;

Schema for azure_location

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
cloud_environmenttextThe Azure Cloud Environment.
display_nametextThe display name of the location.
idtextThe fully qualified ID of the location.
latitudetextThe latitude of the location.
longitudejsonbThe longitude of the location
nametextThe location name
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
subscription_idtext=, !=, ~~, ~~*, !~~, !~~*The Azure Subscription ID in which the resource is located.
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_location