PASSWORD_POLICIES view: New columns

Attention

This behavior change is in the 2023_07 bundle.

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

The Account Usage PASSWORD_POLICIES view behaves as follows:

Before the change:

The PASSWORD_POLICIES view did not include the PASSWORD_MIN_AGE_DAYS and PASSWORD_HISTORY columns.

After the change:

The PASSWORD_POLICIES view includes the PASSWORD_MIN_AGE_DAYS and PASSWORD_HISTORY history columns as follows:

Column Name

Data Type

Description

Notes

PASSWORD_MIN_AGE_DAYS

INT

The number of days a user must wait before a recently changed password can be changed again.

This is the fifteenth ordinal column in the output.

PASSWORD_HISTORY

INT

The number of the most recent passwords that Snowflake stores. These stored passwords cannot be repeated when a user updates their password value.

This is the last column in the output.

Snowflake adds these columns to the view to keep track of properties that are set for the password policy. For details, see Best practices for password policies and passwords.

Ref: 1309