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.

Usage Notes

  • 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.

Back to top