SHOW PIPES

Lists all Pipe objects within a specified scope.

Syntax

-- List all Pipes in the current Schema
SHOW PIPES;
-- List all Pipes in a specified Schema
SHOW PIPES IN SCHEMA schema_name;
-- List all Pipes in a specified Workspace
SHOW PIPES IN WORKSPACE workspace_name;

Return Column Description

Column NameDescription
pipe_namePipe name
pipe_kindPipe type (object storage or Kafka)
statusCurrent status, e.g., RUNNING, PAUSED, INVALID, etc.
copy_statementThe COPY INTO statement associated with the Pipe
DROP PIPE
SHOW CREATE PIPE
Singdata © 2024 Singdata, Inc. All Rights Reserved.