Control: Kubernetes clusters should use standard SKU
Description
Ensure that Kubernetes cluster uses standard SKU tier for production workloads. This control is non-compliant if Kubernetes cluster does not use standard SKU.
Usage
Run the control in your terminal:
powerpipe control run terraform_azure_compliance.control.kubernetes_cluster_sku_standard
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run terraform_azure_compliance.control.kubernetes_cluster_sku_standard --share
SQL
This control uses a named query:
select address as resource, case when (attributes_std ->> 'sku_tier') = 'Standard' then 'ok' else 'alarm' end status, split_part(address, '.', 2) || case when (attributes_std ->> 'sku_tier') = 'Standard' then ' uses standard SKU tier' else ' uses free SKU tier' end || '.' reason , path || ':' || start_linefrom terraform_resourcewhere type = 'azurerm_kubernetes_cluster';