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                                        |
+-------------------------------------------------+