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	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
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
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
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