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