vw_kubernetes_clusters
Creates, updates, deletes, gets or lists a vw_kubernetes_clusters resource.
Overview
| Name | vw_kubernetes_clusters |
| Type | View |
| Id | azure.nexus.vw_kubernetes_clusters |
Fields
See the SQL Definition (view DDL) for fields returned by this view.
SQL Definition
- Sqlite3
- Postgres
SELECT
location as location,
extendedLocation as extended_location,
tags as tags,
JSON_EXTRACT(properties, '$.aadConfiguration') as "aad_configuration",
JSON_EXTRACT(properties, '$.administratorConfiguration') as "administrator_configuration",
JSON_EXTRACT(properties, '$.attachedNetworkIds') as "attached_network_ids",
JSON_EXTRACT(properties, '$.availableUpgrades') as "available_upgrades",
JSON_EXTRACT(properties, '$.clusterId') as "cluster_id",
JSON_EXTRACT(properties, '$.connectedClusterId') as "connected_cluster_id",
JSON_EXTRACT(properties, '$.controlPlaneKubernetesVersion') as "control_plane_kubernetes_version",
JSON_EXTRACT(properties, '$.controlPlaneNodeConfiguration') as "control_plane_node_configuration",
JSON_EXTRACT(properties, '$.detailedStatus') as "detailed_status",
JSON_EXTRACT(properties, '$.detailedStatusMessage') as "detailed_status_message",
JSON_EXTRACT(properties, '$.featureStatuses') as "feature_statuses",
JSON_EXTRACT(properties, '$.initialAgentPoolConfigurations') as "initial_agent_pool_configurations",
JSON_EXTRACT(properties, '$.kubernetesVersion') as "kubernetes_version",
JSON_EXTRACT(properties, '$.managedResourceGroupConfiguration') as "managed_resource_group_configuration",
JSON_EXTRACT(properties, '$.networkConfiguration') as "network_configuration",
JSON_EXTRACT(properties, '$.nodes') as "nodes",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
subscriptionId,
resourceGroupName,
kubernetesClusterName
FROM azure.nexus.kubernetes_clusters
WHERE subscriptionId = 'replace-me';
SELECT
location as location,
extendedLocation as extended_location,
tags as tags,
json_extract_path_text(properties, '$.aadConfiguration') as "aad_configuration",
json_extract_path_text(properties, '$.administratorConfiguration') as "administrator_configuration",
json_extract_path_text(properties, '$.attachedNetworkIds') as "attached_network_ids",
json_extract_path_text(properties, '$.availableUpgrades') as "available_upgrades",
json_extract_path_text(properties, '$.clusterId') as "cluster_id",
json_extract_path_text(properties, '$.connectedClusterId') as "connected_cluster_id",
json_extract_path_text(properties, '$.controlPlaneKubernetesVersion') as "control_plane_kubernetes_version",
json_extract_path_text(properties, '$.controlPlaneNodeConfiguration') as "control_plane_node_configuration",
json_extract_path_text(properties, '$.detailedStatus') as "detailed_status",
json_extract_path_text(properties, '$.detailedStatusMessage') as "detailed_status_message",
json_extract_path_text(properties, '$.featureStatuses') as "feature_statuses",
json_extract_path_text(properties, '$.initialAgentPoolConfigurations') as "initial_agent_pool_configurations",
json_extract_path_text(properties, '$.kubernetesVersion') as "kubernetes_version",
json_extract_path_text(properties, '$.managedResourceGroupConfiguration') as "managed_resource_group_configuration",
json_extract_path_text(properties, '$.networkConfiguration') as "network_configuration",
json_extract_path_text(properties, '$.nodes') as "nodes",
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
subscriptionId,
resourceGroupName,
kubernetesClusterName
FROM azure.nexus.kubernetes_clusters
WHERE subscriptionId = 'replace-me';