vw_rack_skus

Creates, updates, deletes, gets or lists a vw_rack_skus resource.

Overview

Name	vw_rack_skus
Type	View
Id	azure.nexus.vw_rack_skus

Fields

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition

Sqlite3

SELECT
id as id,
name as name,
type as type,
systemData as system_data,
JSON_EXTRACT(properties, '$.computeMachines') as "compute_machines",
JSON_EXTRACT(properties, '$.controllerMachines') as "controller_machines",
JSON_EXTRACT(properties, '$.description') as "description",
JSON_EXTRACT(properties, '$.maxClusterSlots') as "max_cluster_slots",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.rackType') as "rack_type",
JSON_EXTRACT(properties, '$.storageAppliances') as "storage_appliances",
JSON_EXTRACT(properties, '$.supportedRackSkuIds') as "supported_rack_sku_ids",
subscriptionId,
rackSkuName
FROM azure.nexus.rack_skus
WHERE subscriptionId = 'replace-me';

Postgres

SELECT
id as id,
name as name,
type as type,
systemData as system_data,
json_extract_path_text(properties, '$.computeMachines') as "compute_machines",
json_extract_path_text(properties, '$.controllerMachines') as "controller_machines",
json_extract_path_text(properties, '$.description') as "description",
json_extract_path_text(properties, '$.maxClusterSlots') as "max_cluster_slots",
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.rackType') as "rack_type",
json_extract_path_text(properties, '$.storageAppliances') as "storage_appliances",
json_extract_path_text(properties, '$.supportedRackSkuIds') as "supported_rack_sku_ids",
subscriptionId,
rackSkuName
FROM azure.nexus.rack_skus
WHERE subscriptionId = 'replace-me';