azure-steampipe-query

Querying Azure infrastructure via SQL is done using Steampipe CLI with an embedded portable configuration. You write standard SQL statements against Azure resources like virtual machines and storage accounts to retrieve cloud infrastructure data without navigating multiple portals or using complex CLI commands.

Yes, you can query across all company Azure subscriptions at once using a built-in aggregator. This feature provides a unified view of your Azure infrastructure, allowing you to find resources like AKS clusters across all subscriptions with a single SQL query.

Before querying Azure resources with Steampipe, you need the Steampipe CLI installed and Azure CLI authentication configured. You must also complete a one-time bootstrap process to set up an isolated Steampipe environment for your queries.

The best way to find all AKS clusters across multiple Azure subscriptions is to run a SQL query using Steampipe's aggregated view. This allows you to retrieve the cluster names, resource groups, and versions across your entire Azure infrastructure using standard SQL syntax.

Yes, this approach works with an isolated Steampipe environment created during a one-time bootstrap process. The embedded portable configuration ensures predictable schema names and isolated operation when querying Azure infrastructure resources.