Query: kubernetes_cluster_overview

select
  name as "Name",
  id as "Virtual Machine ID",
  type as "Type",
  provisioning_state as "Provisioning State",
  dns_prefix as "DNS Prefix",
  identity ->> 'type' as "Identity Type",
  region as "Region",
  resource_group as "Resource Group",
  subscription_id as "Subscription ID"
from
  azure_kubernetes_cluster
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);