Table: azure_kubernetes_cluster

Azure Kubernetes orchestrates clusters of virtual machines and schedules containers to run on those virtual machines based on their available compute resources and the resource requirements of each container.

Examples

Basic Info

select
  name,
  id,
  location,
  type,
  sku
from
  azure_kubernetes_cluster;

List clusters with a system assigned identity

select
  name,
  id,
  location,
  type,
  identity ->> 'type' as identity_type,
  sku
from
  azure_kubernetes_cluster
where
  identity ->> 'type' = 'SystemAssigned';

List clusters that have role-based access control (RBAC) disabled

select
  name,
  id,
  location,
  type,
  identity,
  enable_rbac,
  sku
from
  azure_kubernetes_cluster
where
  not enable_rbac;

List clusters with an undesirable version (older than 1.20.5)

select
  name,
  id,
  location,
  type,
  kubernetes_version
from
  azure_kubernetes_cluster
where
  kubernetes_version < '1.20.5';

Query examples

Control examples

.inspect azure_kubernetes_cluster

Azure Kubernetes Cluster

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
aad_profile	jsonb	Profile of Azure Active Directory configuration.
addon_profiles	jsonb	Profile of managed cluster add-on.
agent_pool_profiles	jsonb	Properties of the agent pool.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
api_server_access_profile	jsonb	Access profile for managed cluster API server.
auto_scaler_profile	jsonb	Parameters to be applied to the cluster-autoscaler when enabled.
auto_upgrade_profile	jsonb	Profile of auto upgrade configuration.
azure_portal_fqdn	text	FQDN for the master pool which used by proxy config.
cloud_environment	text	The Azure Cloud Environment.
disk_encryption_set_id	text	ResourceId of the disk encryption set to use for enabling encryption at rest.
dns_prefix	text	DNS prefix specified when creating the managed cluster.
enable_pod_security_policy	boolean	Whether to enable Kubernetes pod security policy (preview).
enable_rbac	boolean	Whether to enable Kubernetes Role-Based Access Control.
fqdn	text	FQDN for the master pool.
fqdn_subdomain	text	FQDN subdomain specified when creating private cluster with custom private dns zone.
id	text	The ID of the cluster.
identity	jsonb	The identity of the managed cluster, if configured.
identity_profile	jsonb	Identities associated with the cluster.
kubernetes_version	text	Version of Kubernetes specified when creating the managed cluster.
linux_profile	jsonb	Profile for Linux VMs in the container service cluster.
location	text	The location where the cluster is created.
max_agent_pools	bigint	The max number of agent pools for the managed cluster.
name	text	The name of the cluster.
network_profile	jsonb	Profile of network configuration.
node_resource_group	text	Name of the resource group containing agent pool nodes.
pod_identity_profile	jsonb	Profile of managed cluster pod identity.
power_state	jsonb	Represents the Power State of the cluster.
private_fqdn	text	FQDN of private cluster.
provisioning_state	text	The current deployment or provisioning state.
region	text	The Azure region/location in which the resource is located.
resource_group	text	The resource group which holds this resource.
service_principal_profile	jsonb	Information about a service principal identity for the cluster to use for manipulating Azure APIs.
sku	jsonb	The managed cluster SKU.
subscription_id	text	The Azure Subscription ID in which the resource is located.
tags	jsonb	A map of tags for the resource.
title	text	Title of the resource.
type	text	The type of the cluster.
windows_profile	jsonb	Profile for Windows VMs in the container service cluster.

turbot/azure