MFA_AUTHENTICATION_METHODS is deprecated error

[inkapbang]

Hello,

After I upgrade SnowDDL to 0.59.0, I noticed that it's trying to update authentication policy, which was strange (it was not modified recently).

So, I tried to execute the suggested DDL manually, and I received an error related to MFA_AUTHENTICATION_METHODS being deprecated. Here is the error:
SQL Compilation Error: MFA_AUTHENTICATION_METHODS is deprecated, please use MFA_POLICY=(ENFORCE_MFA_ON_EXTERNAL_AUTHENTICATION=ALL | NONE) instead.

I checked the documentation in SnowDDL, but it seems like MFA_AUTHENTICATION_METHODS is still a valid parameter.

Can you share your thoughts on this please?

[littleK0i]

Snowflake deprecated this parameter recently. So you need to update auth policy definition according to their new requirements.

Also, existing auth policies will be "updated" once because this object type was switched to "short hash" approach instead of actually checking every parameter individually. One ALTER is required in order to add short hash to the comment.

Basically, Snowflake makes this object type too inconsistent and volatile to check it normally.