Skip to main content

DESC STREAM

Introduced or updated: v1.2.223
ENTERPRISE EDITION FEATURE
STREAM is an Enterprise Edition feature. Contact Databend Support for a license.

Describes the details of a specific stream.

Syntax

DESC|DESCRIBE STREAM [ <database_name>. ]<stream_name>

Examples

DESC STREAM books_stream_2023;

┌───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐
│ created_on │ name │ database │ catalog │ table_on │ owner │ commentmode │ invalid_reason │
├────────────────────────────┼───────────────────┼──────────┼─────────┼─────────────────────┼──────────────────┼─────────┼─────────────┼────────────────┤
2023-11-29 02:38:29.588518 │ books_stream_2023 │ defaultdefaultdefault.books_total │ NULL │ │ append_only │ │
└───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘
Try Databend Cloud for FREE

Multimodal, object-storage-native warehouse for BI, vectors, search, and geo.

Snowflake-compatible SQL with automatic scaling.

Sign up and get $200 in credits.

Try it today