helm_charthelm_releasehelm_templatehelm_template_renderedhelm_valuekubernetes_cluster_rolekubernetes_cluster_role_bindingkubernetes_config_mapkubernetes_cronjobkubernetes_custom_resource_definitionkubernetes_daemonsetkubernetes_deploymentkubernetes_endpointkubernetes_endpoint_slicekubernetes_eventkubernetes_horizontal_pod_autoscalerkubernetes_ingresskubernetes_jobkubernetes_limit_rangekubernetes_namespacekubernetes_network_policykubernetes_nodekubernetes_persistent_volumekubernetes_persistent_volume_claimkubernetes_podkubernetes_pod_disruption_budgetkubernetes_pod_security_policykubernetes_pod_templatekubernetes_replicasetkubernetes_replication_controllerkubernetes_resource_quotakubernetes_rolekubernetes_role_bindingkubernetes_secretkubernetes_servicekubernetes_service_accountkubernetes_stateful_setkubernetes_storage_classkubernetes_{custom_resource_singular_name}
Table: helm_release
A Helm release is an instance of a chart running in a Kubernetes cluster. When you use the helm install
command, it creates a release for the chart and generates a set of Kubernetes resources based on the chart's templates and the values provided.
Examples
Basic info
select name, namespace, version, status, first_deployed, chart_namefrom helm_release;
List kubernetes deployment resources deployed using a specific chart
select d.name as deployment_name, d.namespace, d.uid, r.name as release_name, r.chart_name, r.version as release_version, r.first_deployed as deployed_atfrom kubernetes_deployment as d left join helm_release as r on ( d.labels ->> 'app.kubernetes.io/managed-by' = 'Helm' and d.labels ->> 'app.kubernetes.io/instance' = r.name )where r.chart_name = 'ingress-nginx' and d.source_type = 'deployed';
List all deployed releases of a specific chart
select name, namespace, version, status, first_deployed, chart_namefrom helm_releasewhere chart_name = 'ingress-nginx';
List releases from a specific namespace
select name, namespace, version, status, last_deployed, descriptionfrom helm_releasewhere namespace = 'steampipe';
List all failed releases
select name, namespace, version, status, last_deployed, descriptionfrom helm_releasewhere status = 'failed';
List all unfinished releases
select name, namespace, version, status, last_deployed, descriptionfrom helm_releasewhere status = 'pending';
List releases updated in last 3 days
select name, namespace, version, status, last_deployed, descriptionfrom helm_releasewhere last_deployed > (now() - interval '3 days');
Get a specific release
select name, namespace, version, status, last_deployed, descriptionfrom helm_releasewhere name = 'brigade-github-app-1683552635';
.inspect helm_release
List all of the releases of chart in a Kubernetes cluster
Name | Type | Description |
---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. |
chart_name | text | The name of the chart that was released. |
config | jsonb | The set of extra Values added to the chart. These values override the default values inside of the chart. |
deleted | timestamp with time zone | The time when this object was deleted. |
description | text | A human-friendly description about the release. |
first_deployed | timestamp with time zone | The time when the release was first deployed. |
labels | jsonb | The labels of the release. |
last_deployed | timestamp with time zone | The time when the release was last deployed. |
manifest | text | The string representation of the rendered template. |
name | text | The name of the release. |
namespace | text | The kubernetes namespace of the release. |
notes | text | Contains the rendered templates/NOTES.txt if available. |
status | text | The current state of the release. Possible values: deployed, failed, pending-install, pending-rollback, pending-upgrade, superseded, uninstalled, uninstalling, unknown. |
version | bigint | The revision of the release. |