Show Pipelines
Summary
The SHOW PIPELINES command returns a result set listing metadata for all pipeline objects defined in the Connect environment.
Syntax
show pipelines; |
Parameters
None.
Details
The SHOW PIPELINES result set includes the following columns.
|
Column Name
|
Data Type
|
Description
|
|---|---|---|
| id | string | Unique identifier for each pipeline object |
| name | string | Pipeline name given by developer |
| description | string | Notes a developer added to the pipeline object |
| members | string | For internal use. A json object containing metadata about the steps and sub-pipelines assigned to the parent pipeline object. Refer to the singular SHOW PIPELINE command to list the pipeline members. |
| labels | string | A descriptive tag that a developer added to describe the purpose of the pipeline. Refer to ALTER PIPELINE “add label”. |
| created_by | string | Connect developer who created the pipeline |
| created_instant | instant | Instant when a developer created the pipeline |
| modified_by | string | Connect developer who last modified the pipeline |
| modified_instant | instant | Instant when a developer last modified a pipeline |
Examples
show pipelines;
select name, labels, modified_instant
from (show pipelines)
where name like ‘p_pay%’;
Related Commands