steampipe plugin install azure

Table: azure_compute_resource_sku - Query Azure Compute Resource SKUs using SQL

Azure Compute Resource SKUs represent the purchasable SKUs of Azure virtual machines. These SKUs detail the capabilities, restrictions, and pricing tiers of the available virtual machines. This information is crucial for understanding the options and limitations when deploying Azure virtual machines.

Table Usage Guide

The azure_compute_resource_sku table provides insights into Azure Compute Resource SKUs. As a cloud architect or DevOps engineer, use this table to explore the capabilities, restrictions, and pricing tiers of available Azure virtual machines. Utilize it to make informed decisions on the deployment and scaling of Azure virtual machines based on their SKU details.

Examples

Compute resources sku info

Explore the different tiers, sizes, and types of compute resources available in your Azure environment. This can help you understand your options and plan your resource allocation more effectively.

select
name,
tier,
size,
family,
kind
from
azure_compute_resource_sku;
select
name,
tier,
size,
family,
kind
from
azure_compute_resource_sku;

Azure compute resources and their capacity

Analyze the settings to understand the capacity range of Azure compute resources. This can help in assessing the scalability of your resources and planning for future capacity needs.

select
name,
default_capacity,
maximum_capacity,
minimum_capacity
from
azure_compute_resource_sku;
select
name,
default_capacity,
maximum_capacity,
minimum_capacity
from
azure_compute_resource_sku;

List of all premium type disks and location

Determine the areas in which premium type disks are located to optimize resource management and allocation strategies. This can be particularly useful in identifying potential cost savings or efficiency improvements.

select
name,
resource_type tier,
l as location
from
azure_compute_resource_sku,
jsonb_array_elements_text(locations) as l
where
resource_type = 'disks'
and tier = 'Premium';
select
name,
resource_type as tier,
json_each.value as location
from
azure_compute_resource_sku,
json_each(locations)
where
resource_type = 'disks'
and tier = 'Premium';

Schema for azure_compute_resource_sku

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
api_versionsjsonbThe api versions that support this SKU
capabilitiesjsonbA name value pair to describe the capability
cloud_environmenttextThe Azure Cloud Environment.
costsjsonbA list of metadata for retrieving price info
default_capacitybigintContains the default capacity
familytextThe Family of this particular SKU
kindtextThe Kind of resources that are supported in this SKU
location_infojsonbA list of locations and availability zones in those locations where the SKU is available
locationsjsonbThe set of locations that the SKU is available
maximum_capacitybigintThe maximum capacity that can be set
minimum_capacitybigintThe minimum capacity that can be set
nametextThe name of SKU
resource_typetextThe type of resource the SKU applies to
restrictionsjsonbThe restrictions because of which SKU cannot be used
scale_typetextThe scale type applicable to the sku
sizetextThe Size of the SKU
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
subscription_idtext=, !=, ~~, ~~*, !~~, !~~*The Azure Subscription ID in which the resource is located.
tiertextSpecifies the tier of virtual machines in a scale set
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_compute_resource_sku