PIPES views and commands: New column¶

Attention

This behavior change is in the 2026_01 bundle.

For the current status of the bundle, refer to Bundle history.

When this behavior change bundle is enabled, the following commands and views include the new column IS_SNOWFLAKE_MANAGED:

SHOW PIPES command: New column in output
DESCRIBE PIPES command: New column in output
PIPES view (Account Usage): New column
PIPES view (Organization Usage): New column

Column name	Data type	Description
IS_SNOWFLAKE_MANAGED	BOOLEAN	Indicates whether the pipe is managed by Snowflake. If TRUE, the pipe is a Snowflake-managed default pipe for Snowpipe Streaming with high-performance architecture. Snowflake automatically creates and manages default pipes for every target table, so that you can start streaming data immediately without creating a pipe manually. For more information, see Default pipe. If FALSE, the pipe is user-managed.

Column name

Data type

Description

IS_SNOWFLAKE_MANAGED

BOOLEAN

Indicates whether the pipe is managed by Snowflake.

If TRUE, the pipe is a Snowflake-managed default pipe for Snowpipe Streaming with high-performance architecture. Snowflake automatically creates and manages default pipes for every target table, so that you can start streaming data immediately without creating a pipe manually. For more information, see Default pipe.

If FALSE, the pipe is user-managed.

Ref: 2137