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.