DESCRIBE SESSION POLICY command: convert output from row-oriented to column-oriented (Preview)¶

To provide consistency with DESC [SESSION, AUTHENTICATION, PASSWORD] POLICY, and enable future expansion of DESCRIBE SESSION POLICY without breaking changes, the DESC SESSION POLICY and USE SECONDARY ROLES commands behave as follows:

Before the change:

DESC SESSION POLICY returns a single row, with one column per property.

USE SECONDARY ROLES fails if one of the requested roles is disallowed by session policy or is not granted to the user.

After the change:

DESC SESSION POLICY returns one row per property. This change aligns how Snowflake describes session policies with how Snowflake describes authentication and password policies.

USE SECONDARY ROLES fails only if the user is not granted one of the requested roles.

Ref: 1985