steampipe plugin install azuresteampipe 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

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
api_versions	jsonb	The api versions that support this SKU
capabilities	jsonb	A name value pair to describe the capability
cloud_environment	text	The Azure Cloud Environment.
costs	jsonb	A list of metadata for retrieving price info
default_capacity	bigint	Contains the default capacity
family	text	The Family of this particular SKU
kind	text	The Kind of resources that are supported in this SKU
location_info	jsonb	A list of locations and availability zones in those locations where the SKU is available
locations	jsonb	The set of locations that the SKU is available
maximum_capacity	bigint	The maximum capacity that can be set
minimum_capacity	bigint	The minimum capacity that can be set
name	text	The name of SKU
resource_type	text	The type of resource the SKU applies to
restrictions	jsonb	The restrictions because of which SKU cannot be used
scale_type	text	The scale type applicable to the sku
size	text	The Size of the SKU
subscription_id	text	The Azure Subscription ID in which the resource is located.
tier	text	Specifies the tier of virtual machines in a scale set
title	text	Title 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