_ESP_Streams

Contains information about all streams, delta streams, and windows.

Column Type Description
user_name string Hardcoded as "user".
stream_name string The name of the stream described by this row.
handle long The stream's numeric ID.
type string The type of the stream: "stream", "deltastream", "window", or "metadata".
visibility string The visibility of the stream: "input", "output", "local", or "intermediate".
target string The name of the target stream for streams with "intermediate" visibility value. For streams with all other visibility values, target is the same as the stream_name column.
gdmode integer Indicates whether guaranteed delivery is enabled for the stream:
  • 0 - does not support guaranteed delivery
  • 1 - supports guaranteed delivery
  • 2 - supports guaranteed delivery with check points
Guaranteed delivery with check points is available only when the server is running in consistent recovery mode or the auto check point option is enabled.