SHOW and DESCRIBE commands for listings: New columns in output (Pending)¶

Attention

This behavior change is in the 2024_08 bundle.

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

When this behavior change bundle is enabled, the output of the following listing commands are changed:

When enabled, the output of these commands includes the following new columns:

Column name	Data type	Description
distribution	VARCHAR	Defines where a listing’s data is distributed in relation to the organization. Possible values are `EXTERNAL` and `INTERNAL`.
is_mountless_queryable	BOOLEAN	Indicates whether the consumer can query the listing directly, without needing to retrieve (GET) the listing and create a local database in their account. If set to `TRUE`, the consumer can run queries directly on the data through the listing itself.
organization_profile_name	VARCHAR	The provider profile for an organization. For an organizational listing, this value is set to `INTERNAL`.
unified_listing_locator	VARCHAR	The unique identifier that represents a listing and its data product as one entity. This value is either set by the provider or generated by Snowflake.

Ref: 1756