Table: heroku_app_release - Query Heroku App Releases using SQL

Heroku is a platform as a service (PaaS) that enables developers to build, run, and operate applications entirely in the cloud. It supports several programming languages and allows developers to deploy, manage, and scale applications without the need for infrastructure. Heroku App Releases are a record of every deploy to an app, and each release has a unique version number that increments with each release.

Table Usage Guide

The heroku_app_release table provides insights into each app release within Heroku. As a developer or a DevOps engineer, you can explore details about each app release, including its version number, status, and description. Utilize this table to track the history of app releases, identify any changes made, and monitor the overall progress of app development.

Important Notes

List queries require an app_name.
Get queries require an app_name, a release id or a release version.
Pagination is not currently supported for this resource type in the SDK.

Examples

List all app releases

Explore all releases of a specific application, identifying their versions, statuses, and creation dates. This can be used to track the app's development history and assess the implementation of current and past versions.

select
  id,
  status,
  version,
  is_current,
  created_at
from
  heroku_app_release
where
  app_name = 'steampipe';

select
  id,
  status,
  version,
  is_current,
  created_at
from
  heroku_app_release
where
  app_name = 'steampipe';

Get the current release version of an app

Explore the current release version of an app to stay updated on its status and creation date. This is useful for maintaining app version control and ensuring you're working with the most recent release.

select
  id,
  status,
  version,
  is_current,
  created_at
from
  heroku_app_release
where
  app_name = 'steampipe'
  and is_current;

select
  id,
  status,
  version,
  is_current,
  created_at
from
  heroku_app_release
where
  app_name = 'steampipe'
  and is_current;

Get the release information of an app by release ID

Explore the version history of a specific application, such as when the version was created and whether it's the current one, to understand its update timeline and status. This is particularly useful for tracking the app's development and ensuring it's up-to-date.

select
  id,
  status,
  version,
  is_current,
  created_at
from
  heroku_app_release
where
  app_name = 'steampipe'
  and id = 'e8256596-5583-4df0-9a6d-cf0af5e11f02';

select
  id,
  status,
  version,
  is_current,
  created_at
from
  heroku_app_release
where
  app_name = 'steampipe'
  and id = 'e8256596-5583-4df0-9a6d-cf0af5e11f02';

Get the release information of an app by release version

Explore the status of a specific version of an app to understand if it's the current version and when it was created. This can be useful to track the history and updates of the app.

select
  id,
  status,
  version,
  is_current,
  created_at
from
  heroku_app_release
where
  app_name = 'steampipe'
  and version = 4;

select
  id,
  status,
  version,
  is_current,
  created_at
from
  heroku_app_release
where
  app_name = 'steampipe'
  and version = 4;

Schema for heroku_app_release

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	Unique identifier of an account.
addon_plan_names	jsonb		Add-on plans installed on the app for this release.
app_name	text	=	ACM status of this app.
created_at	timestamp with time zone		When release was created.
description	text		Description of changes in this release
id	text	=	Unique identifier of release.
is_current	boolean		Indicates this release as being the current one for the app.
output_stream_url	text		Release command output will be available from this URL as a stream.
slug	jsonb		Slug running in this release.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		Current status of the release.
updated_at	timestamp with time zone		When release was updated.
user	jsonb		User that created the release.
version	bigint	=	Unique version assigned to the release.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- heroku

You can pass the configuration to the command with the --config argument:

steampipe_export_heroku --config '<your_config>' heroku_app_release