SHOW STREAMS command: Change in output for streams on directory tables (Preview)¶

Attention

This behavior change is in the 2026_01 bundle.

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

The SHOW STREAMS command for streams created on directory tables (for example, stages with the DIRECTORY = (ENABLE=TRUE) property) behaves as follows:

Before the change:: The output for the table_name and base_tables columns in the SHOW STREAMS command returns the unqualified name of the stage for streams on a stage with directory tables enabled. For example, mystage.
After the change:: The output for the table_name and base_tables columns in the SHOW STREAMS command returns the fully qualified name of the stage for streams on a stage with directory stables enabled. For example, my_db.my_schema.test_stage.

Ref: 2170