vw_storage_classes

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

Overview

Name	vw_storage_classes
Type	View
Id	azure.k8s_runtime.vw_storage_classes

Fields

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

SQL Definition

Sqlite3

SELECT
JSON_EXTRACT(properties, '$.allowVolumeExpansion') as "allow_volume_expansion",
JSON_EXTRACT(properties, '$.mountOptions') as "mount_options",
JSON_EXTRACT(properties, '$.provisioner') as "provisioner",
JSON_EXTRACT(properties, '$.volumeBindingMode') as "volume_binding_mode",
JSON_EXTRACT(properties, '$.accessModes') as "access_modes",
JSON_EXTRACT(properties, '$.dataResilience') as "data_resilience",
JSON_EXTRACT(properties, '$.failoverSpeed') as "failover_speed",
JSON_EXTRACT(properties, '$.limitations') as "limitations",
JSON_EXTRACT(properties, '$.performance') as "performance",
JSON_EXTRACT(properties, '$.priority') as "priority",
JSON_EXTRACT(properties, '$.typeProperties') as "type_properties",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
resourceUri,
storageClassName
FROM azure.k8s_runtime.storage_classes
WHERE resourceUri = 'replace-me';

Postgres

SELECT
json_extract_path_text(properties, '$.allowVolumeExpansion') as "allow_volume_expansion",
json_extract_path_text(properties, '$.mountOptions') as "mount_options",
json_extract_path_text(properties, '$.provisioner') as "provisioner",
json_extract_path_text(properties, '$.volumeBindingMode') as "volume_binding_mode",
json_extract_path_text(properties, '$.accessModes') as "access_modes",
json_extract_path_text(properties, '$.dataResilience') as "data_resilience",
json_extract_path_text(properties, '$.failoverSpeed') as "failover_speed",
json_extract_path_text(properties, '$.limitations') as "limitations",
json_extract_path_text(properties, '$.performance') as "performance",
json_extract_path_text(properties, '$.priority') as "priority",
json_extract_path_text(properties, '$.typeProperties') as "type_properties",
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
resourceUri,
storageClassName
FROM azure.k8s_runtime.storage_classes
WHERE resourceUri = 'replace-me';