Lists pipelines declared in the current session, optionally filtered by a LIKE pattern.
SHOW PIPELINES [LIKE '<pattern>']## Overview SHOW PIPELINES returns one row per pipeline declared in the current session via the PIPELINE statement. It does not list pipelines persisted in the Control Plane catalog. ## Behavior - The result reflects only the executor's in-session `declared_pipelines` registry. Pipelines persisted via the Control Plane API are not included. - The optional LIKE clause filters by name using SQL wildcards. The match is case-insensitive. - The result columns include the pipeline name and its declared metadata (description, schedule reference, fail_fast, lifecycle, and so on). ## Access Control No specific privilege is required. ## Compatibility DeltaForge extension.
| Name | Type | Description |
|---|---|---|
pattern | Optional case-insensitive LIKE pattern. SQL wildcards `%` and `_` are honored. |
-- List every pipeline declared in this session
SHOW PIPELINES;-- Filter by prefix
SHOW PIPELINES LIKE 'daily_%';