Schema:: ACCOUNT_USAGE

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);