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_name
from
  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_at
from
  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_name
from
  helm_release
where
  chart_name = 'ingress-nginx';

List releases from a specific namespace

select
  name,
  namespace,
  version,
  status,
  last_deployed,
  description
from
  helm_release
where
  namespace = 'steampipe';

List all failed releases

select
  name,
  namespace,
  version,
  status,
  last_deployed,
  description
from
  helm_release
where
  status = 'failed';

List all unfinished releases

select
  name,
  namespace,
  version,
  status,
  last_deployed,
  description
from
  helm_release
where
  status = 'pending';

List releases updated in last 3 days

select
  name,
  namespace,
  version,
  status,
  last_deployed,
  description
from
  helm_release
where
  last_deployed > (now() - interval '3 days');

Get a specific release

select
  name,
  namespace,
  version,
  status,
  last_deployed,
  description
from
  helm_release
where
  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.

turbot/kubernetes