DESCRIBE AVAILABLE LISTING and DESCRIBE LISTING commands: New column in output (Preview)¶

Attention

This behavior change is in the 2025_03 bundle.

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

When this behavior change bundle is enabled, the output of the DESCRIBE AVAILABLE LISTING and DESCRIBE LISTING commands will contain the following new column:

Column name	Description
REQUEST_APPROVAL_TYPE	Displays the organization listing access request type. The access request type defines how discovery targets of a listing submit access requests to the listing approver. Returned values include `NULL`, `REQUEST_AND_APPROVE_IN_SNOWFLAKE`, and `REQUEST_AND_APPROVE_OUTSIDE_SNOWFLAKE`. `REQUEST_AND_APPROVE_IN_SNOWFLAKE` indicates access requests are submitted and approved within the Snowflake environment. `REQUEST_AND_APPROVE_OUTSIDE_SNOWFLAKE` indicates the provider manages access request submissions and approvals independently. The value for external listings is always `NULL`.

Column name

Description

REQUEST_APPROVAL_TYPE

Displays the organization listing access request type. The access request type defines how discovery targets of a listing submit access requests to the listing approver.

Returned values include NULL, REQUEST_AND_APPROVE_IN_SNOWFLAKE, and REQUEST_AND_APPROVE_OUTSIDE_SNOWFLAKE. REQUEST_AND_APPROVE_IN_SNOWFLAKE indicates access requests are submitted and approved within the Snowflake environment. REQUEST_AND_APPROVE_OUTSIDE_SNOWFLAKE indicates the provider manages access request submissions and approvals independently. The value for external listings is always NULL.

Ref: 1962