Categories:

System Functions (System Control)

SYSTEM$DISABLE_BEHAVIOR_CHANGE_BUNDLE

Disables the behavior changes included in the specified release bundle for the current account.

This command becomes available for a particular bundle at the beginning of the testing period for that bundle and becomes unavailable after the opt-out period for that bundle. Issuing this command with a bundle before the testing period for that bundle begins or after the opt-out period for that bundle ends returns an error.

If you use this command to disable a behavior change bundle during the testing period, the bundle remains disabled until you enable it again or until the end of the opt-out period. Snowflake does not override this setting at the beginning of the opt-out period, when the bundle becomes enabled by default.

See also:

SYSTEM$ENABLE_BEHAVIOR_CHANGE_BUNDLE, SYSTEM$BEHAVIOR_CHANGE_BUNDLE_STATUS

Syntax

SYSTEM$DISABLE_BEHAVIOR_CHANGE_BUNDLE( <bundle_name> )

Arguments

bundle_name

Name of the behavior change bundle. To obtain the name for a bundle, see the Pending Behavior Change Log in the Snowflake Community.

Returns

Returns the VARCHAR value DISABLED if the function successfully disables the behavior changes.

Examples

select SYSTEM$DISABLE_BEHAVIOR_CHANGE_BUNDLE('2020_08');

+--------------------------------------------------+
| SYSTEM$DISABLE_BEHAVIOR_CHANGE_BUNDLE('2020_08') |
|--------------------------------------------------|
| DISABLED                                         |
+--------------------------------------------------+