SHOW AVAILABLE LISTINGS command: New columns in output

Attention

This behavior change is in the 2026_01 bundle.

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

When this behavior change bundle is enabled, the output of the SHOW AVAILABLE LISTINGS command includes two new columns. These columns are only populated with data for Internal Marketplace (organization) listings. For other listings, the columns show null values.

Column nameDescription
discover_onlyIndicates whether a listing is discoverable.
is_data_available_to_queryIndicates whether a listing exposes any data objects in the consumer account that can be queried.

Ref: 2201