Table: heroku_pipeline - Query Heroku Pipelines using SQL

Heroku Pipelines is a sequence of stages (review, development, staging, production) representing the lifecycle of an application. It provides a visual representation of the process that an app goes through from source code to deployment. Heroku Pipelines helps teams to manage the progress of features and fixes from review apps to staging and production.

Table Usage Guide

The heroku_pipeline table provides insights into the lifecycle of applications on the Heroku platform. As a DevOps engineer, explore pipeline-specific details through this table, including the stages of application development and deployment. Utilize it to uncover information about pipelines, such as the status of application development stages, and the verification of deployment processes.

Examples

List all pipelines

Note: The Heroku Go SDK does not yet support listing pipelines.

Get a pipeline by ID

Explore which pipeline corresponds to a specific ID to manage or troubleshoot your Heroku deployment. This is useful in scenarios where you need to quickly identify and access a specific pipeline based on its unique identifier.

select
  *
from
  heroku_pipeline
where
  id = '3d48ef48-1360-414e-9183-ca97ae134b1a';

select
  *
from
  heroku_pipeline
where
  id = '3d48ef48-1360-414e-9183-ca97ae134b1a';

Schema for heroku_pipeline

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	Unique identifier of an account.
created_at	timestamp with time zone		When pipeline was created.
id	text	=	Unique identifier of pipeline.
name	text		Name of pipeline.
owner	jsonb		Owner of a pipeline.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
updated_at	timestamp with time zone		When pipeline was updated.

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_pipeline