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	VARCHAR	Database that the pipe belongs to
PIPE_SCHEMA	VARCHAR	Schema that the pipe belongs to
PIPE_NAME	VARCHAR	Name of the pipe
PIPE_OWNER	VARCHAR	Name of the role that owns the pipe
DEFINITION	VARCHAR	COPY statement used to load data from queued files into a Snowflake table.
IS_AUTOINGEST_ENABLED	VARCHAR	Whether AUTO-INGEST is enabled for the pipe. Represents future functionality.
NOTIFICATION_CHANNEL_NAME	VARCHAR	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	Date and time the object was last altered by a DML, DDL, or background metadata operation. See Usage Notes.
COMMENT	VARCHAR	Comment for this pipe
PATTERN	VARCHAR	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.
The LAST_ALTERED column is updated when the following operations are performed on an object:
- DDL operations.
- DML operations (for tables only). This column is updated even when no rows are affected by the DML statement.
- Background maintenance operations on metadata performed by Snowflake.