SHOW <class_name> INSTANCES commands: Changes in output (Pending)

Attention

This behavior change is in the 2024_07 bundle.

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

The SHOW <class_name> INSTANCES command for individual Snowflake classes list the instances for which you have access privileges. For example, the SHOW SNOWFLAKE.CORE.BUDGET INSTANCES command lists the budgets in your account that you have access privileges for. For a full list, see Available classes.

When this behavior change bundle is enabled, the output of the SHOW <class_name> INSTANCES command changes as follows:

Before the change:

Results are returned in lexicographical order by name.

After the change:

Result order is not guaranteed.

Ref: 1735