Categories:

System Functions (System Control)

SYSTEM$BEHAVIOR_CHANGE_BUNDLE_STATUS

Returns the status of the specified behavior change release bundle for the current account.

See also:

SYSTEM$ENABLE_BEHAVIOR_CHANGE_BUNDLE, SYSTEM$DISABLE_BEHAVIOR_CHANGE_BUNDLE

Syntax

SYSTEM$BEHAVIOR_CHANGE_BUNDLE_STATUS( <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 one of the following VARCHAR values:

  • ENABLED (if the specified bundle is enabled for the current account)

  • DISABLED (if the specified bundle is disabled for the current account)

Examples

select SYSTEM$BEHAVIOR_CHANGE_BUNDLE_STATUS('2020_08');

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