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

Usage Notes

  • The view only displays objects for which the current role for the session has been granted access privileges. The view does not honor the MANAGE GRANTS privilege and consequently may show less information compared to a SHOW command when both are executed by a user who holds the MANAGE GRANTS privilege.