Categories:

Table Functions



## Arguments¶

stream_name

The name of the stream to query.

• Note that the entire name must be enclosed in single quotes, including the database and schema, if the name is fully-qualified, (i.e. '<db>.<schema>.<stream_name>').

• If the stream name is case-sensitive or includes any special characters or spaces, double quotes are required to process the case/characters. The double quotes must be enclosed within the single quotes, i.e. '"<stream_name>"'.

N/A

## Examples¶

Retrieve the current set of unconsumed table versions for stream db1.schema1.s1:

SELECT * FROM TABLE(SYSTEM\$STREAM_BACKLOG('db1.schema1.s1'));