PIPES View

This Account Usage view displays a row for each pipe defined in the account.

Columns

Column Name	Data Type	Description
PIPE_ID	TEXT	Internal/system-generated identifier for the pipe.
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

• Latency for the view may be up to 180 minutes (3 hours).

• The view only displays objects for which the current role for the session has been granted access privileges.

• The view does not recognize the MANAGE GRANTS privilege and consequently may show less information compared to a SHOW command executed by a user who holds the MANAGE GRANTS privilege.

Examples

The following example joins this view with PIPE_USAGE_HISTORY View on the PIPE_ID column to track the credit usage associated with each unique PIPE object:

select a.PIPE_CATALOG as PIPE_CATALOG,
       a.PIPE_SCHEMA as PIPE_SCHEMA,
       a.PIPE_NAME as PIPE_NAME,
       b.CREDITS_USED as CREDITS_USED
from PIPES a join PIPE_USAGE_HISTORY b
on a.pipe_id = b.pipe_id
where b.START_TIME > date_trunc(month, current_date);