SHOW and DESCRIBE commands for listings: New columns in output¶
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