SHOW USERS command: NULL values replace default values in output¶

When this behavior change bundle is enabled, the output of the SHOW USERS command changes as follows:

Before the change:

Certain output columns show default values (such as an empty string or false) rather than actual NULL values. This behavior occurs both when the current user does not have access to the column value and when the property for the user in question is not defined.

For example, create a user named nulltest:

CREATE OR REPLACE USER nulltest DISPLAY_NAME = 'iamnull';

Copy

The SHOW USERS command for this new user returns an empty string for undefined properties such as first_name, last_name, and email.

After the change:

NULL is used to represent expected NULL values, instead of an empty string, false, and so on. For example, create a user named nulltest:

CREATE OR REPLACE USER nulltest DISPLAY_NAME = 'iamnull';

Copy

The SHOW USERS command for this new user returns NULL values for undefined properties such as first_name, last_name, and email.

This change affects the following SHOW USERS output columns:

• name

• comment

• display_name

• email

• first_name

• last_name

• has_password

• has_rsa_public_key

• has_mfa

• namespace

• warehouse

• default_role

• login_name

• disabled

• snowflake_lock

• must_change_password

• mins_to_unlock

• days_to_expiry

• mins_to_bypass_mfa

• default_secondary_roles

Ref: 1798