vw_provisioned_cluster_instances
Creates, updates, deletes, gets or lists a vw_provisioned_cluster_instances resource.
Overview
| Name | vw_provisioned_cluster_instances |
| Type | View |
| Id | azure.hybrid_aks.vw_provisioned_cluster_instances |
Fields
See the SQL Definition (view DDL) for fields returned by this view.
SQL Definition
- Sqlite3
- Postgres
SELECT
extendedLocation as extended_location,
JSON_EXTRACT(properties, '$.linuxProfile') as "linux_profile",
JSON_EXTRACT(properties, '$.controlPlane') as "control_plane",
JSON_EXTRACT(properties, '$.kubernetesVersion') as "kubernetes_version",
JSON_EXTRACT(properties, '$.networkProfile') as "network_profile",
JSON_EXTRACT(properties, '$.storageProfile') as "storage_profile",
JSON_EXTRACT(properties, '$.clusterVMAccessProfile') as "cluster_vm_access_profile",
JSON_EXTRACT(properties, '$.agentPoolProfiles') as "agent_pool_profiles",
JSON_EXTRACT(properties, '$.cloudProviderProfile') as "cloud_provider_profile",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.status') as "status",
JSON_EXTRACT(properties, '$.licenseProfile') as "license_profile",
JSON_EXTRACT(properties, '$.autoScalerProfile') as "auto_scaler_profile",
connectedClusterResourceUri
FROM azure.hybrid_aks.provisioned_cluster_instances
WHERE connectedClusterResourceUri = 'replace-me';
SELECT
extendedLocation as extended_location,
json_extract_path_text(properties, '$.linuxProfile') as "linux_profile",
json_extract_path_text(properties, '$.controlPlane') as "control_plane",
json_extract_path_text(properties, '$.kubernetesVersion') as "kubernetes_version",
json_extract_path_text(properties, '$.networkProfile') as "network_profile",
json_extract_path_text(properties, '$.storageProfile') as "storage_profile",
json_extract_path_text(properties, '$.clusterVMAccessProfile') as "cluster_vm_access_profile",
json_extract_path_text(properties, '$.agentPoolProfiles') as "agent_pool_profiles",
json_extract_path_text(properties, '$.cloudProviderProfile') as "cloud_provider_profile",
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.status') as "status",
json_extract_path_text(properties, '$.licenseProfile') as "license_profile",
json_extract_path_text(properties, '$.autoScalerProfile') as "auto_scaler_profile",
connectedClusterResourceUri
FROM azure.hybrid_aks.provisioned_cluster_instances
WHERE connectedClusterResourceUri = 'replace-me';