Behavior Change Release Management¶
This document explains how to check whether a particular behavior change release is enabled in your account and how to enable or disable it.
In this Topic:
Overview¶
Snowflake releases behavior changes in monthly behavior change releases. During the testing period and opt-out period for each behavior change release, you can enable or disable the release in your account. This document explains how to check whether a particular release is enabled in your account and how to enable or disable it.
In this document, <bundle_name> is the name of the behavior change release bundle in the form YYYY_MM, found in the Behavior Change Log document.
Checking the Status of a Behavior Change Release on Your Account¶
To check whether a specific behavior change is enabled on your account, use the SYSTEM$BEHAVIOR_CHANGE_BUNDLE_STATUS function with the <bundle_name> as an argument.
SELECT SYSTEM$BEHAVIOR_CHANGE_BUNDLE_STATUS('2021_02'); +-------------------------------------------------+ | SYSTEM$BEHAVIOR_CHANGE_BUNDLE_STATUS('2021_02') | |-------------------------------------------------| | DISABLED | +-------------------------------------------------+
Enabling a Behavior Change Release on Your Account¶
To enable a particular behavior change on your account, use the SYSTEM$ENABLE_BEHAVIOR_CHANGE_BUNDLE function with the release name as an argument.
SELECT SYSTEM$ENABLE_BEHAVIOR_CHANGE_BUNDLE('2021_02'); +-------------------------------------------------+ | SYSTEM$ENABLE_BEHAVIOR_CHANGE_BUNDLE('2021_02') | |-------------------------------------------------| | ENABLED | +-------------------------------------------------+
Disabling a Behavior Change Release on Your Account¶
To disable a particular behavior change on your account, use the SYSTEM$DISABLE_BEHAVIOR_CHANGE_BUNDLE function with the release name as an argument:
SELECT SYSTEM$DISABLE_BEHAVIOR_CHANGE_BUNDLE('2021_02'); +-------------------------------------------------+ | SYSTEM$DISABLE_BEHAVIOR_CHANGE_BUNDLE('2021_02')| |-------------------------------------------------| | DISABLED | +-------------------------------------------------+