steampipe plugin install azure

Table: azure_provider - Query Azure Providers using SQL

An Azure Provider is a service that supplies the resources you can deploy and manage through Resource Manager. Each resource provider offers operations for working with the resources that are deployed. Some common resource providers are Microsoft.Compute, which supplies the virtual machine resource, Microsoft.Storage, which supplies the storage account resource, and Microsoft.Web, which supplies resources related to web apps.

Table Usage Guide

The azure_provider table provides insights into Azure providers within Microsoft Azure Resource Manager. As a DevOps engineer, explore provider-specific details through this table, including registration status, namespace, and other related properties. Utilize it to uncover information about providers, such as their registration state, the resources they supply, and their corresponding operations.

Examples

Basic info

Determine the areas in which your Azure provider is registered. This is useful for understanding your Azure resources and their distribution.

select
id,
namespace,
registration_state
from
azure_provider;
select
id,
namespace,
registration_state
from
azure_provider;

List of azure providers which are not registered for use

Identify the Azure providers that are not yet registered for use. This is useful to ensure all necessary providers are properly set up and ready for use in your Azure environment.

select
namespace,
registration_state
from
azure_provider
where
registration_state = 'NotRegistered';
select
namespace,
registration_state
from
azure_provider
where
registration_state = 'NotRegistered';

Schema for azure_provider

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
cloud_environmenttextThe Azure Cloud Environment.
idtextContains ID to identify a resource provider uniquely.
namespacetext=The friendly name that identifies the resource provider.
registration_statetextContains the current registration state of the resource provider.
resource_typesjsonbA list of provider resource types.
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_provider