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;

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