PIPES View¶

This Information Schema view displays a row for each pipe defined in the specified (or current) database.

Columns¶

Column Name	Data Type	Description
PIPE_CATALOG	TEXT	Database that the pipe belongs to
PIPE_SCHEMA	TEXT	Schema that the pipe belongs to
PIPE_NAME	TEXT	Name of the pipe
PIPE_OWNER	TEXT	Name of the role that owns the pipe
DEFINITION	TEXT	COPY statement used to load data from queued files into a Snowflake table.
IS_AUTOINGEST_ENABLED	TEXT	Whether AUTO-INGEST is enabled for the pipe. Represents future functionality.
NOTIFICATION_CHANNEL_NAME	TEXT	Amazon Resource Name of the Amazon SQS queue for the stage named in the DEFINITION column. Represents future functionality.
CREATED	TIMESTAMP_LTZ	Creation time of the pipe
LAST_ALTERED	TIMESTAMP_LTZ	Last altered time of the pipe
COMMENT	TEXT	Comment for this pipe
PATTERN	TEXT	PATTERN copy option value in the COPY INTO <table> statement in the pipe definition, if the copy option was specified.

Returns results only for the pipe owner (i.e. the role with the OWNERSHIP privilege on the pipe) or a role with the MONITOR privilege on the pipe.
To determine the current status of a pipe, query the SYSTEM$PIPE_STATUS function.