Categories:

System functions (System Information)

SYSTEM$SHOW_ACTIVE_BEHAVIOR_CHANGE_BUNDLES

Returns an array of the currently available behavior change release bundles, the default state of each bundle, and the actual state of the bundle for the current account.

See also:

SYSTEM$ENABLE_BEHAVIOR_CHANGE_BUNDLE, SYSTEM$DISABLE_BEHAVIOR_CHANGE_BUNDLE, SYSTEM$BEHAVIOR_CHANGE_BUNDLE_STATUS

Syntax

SYSTEM$SHOW_ACTIVE_BEHAVIOR_CHANGE_BUNDLES()

Arguments

None.

Returns

Returns a VARCHAR value that contains an array of objects that represent the currently available behavior change bundles. Each object contains the following keys, which describe the status of the bundle:

Key

Description of value

name

Name of the behavior change bundle

isDefault

true if the associated bundle should be enabled by default for the current account; false otherwise.

isEnabled

true if the associated bundle is actually enabled by default for the current account; false otherwise.

Usage notes

Examples

The following example returns information about the current behavior change bundles.

SELECT SYSTEM$SHOW_ACTIVE_BEHAVIOR_CHANGE_BUNDLES();

+--------------------------------------------------------------------------------------------------------------+
| SYSTEM$SHOW_ACTIVE_BEHAVIOR_CHANGE_BUNDLES()                                                                 |
|--------------------------------------------------------------------------------------------------------------|
| [{"name":"2023_08","isDefault":true,"isEnabled":true},{"name":"2024_01","isDefault":false,"isEnabled":true}] |
+--------------------------------------------------------------------------------------------------------------+

The following example uses the PARSE_JSON function to return the array as a VARIANT and then uses the FLATTEN function to present the bundle information in a tabular format.

SELECT
    bundles.VALUE:name::VARCHAR AS bundle_name,
    bundles.VALUE:isDefault::BOOLEAN AS is_enabled_by_default,
    bundles.VALUE:isEnabled::BOOLEAN AS is_actually_enabled_in_account
  FROM
    TABLE(FLATTEN(input => PARSE_JSON(SYSTEM$SHOW_ACTIVE_BEHAVIOR_CHANGE_BUNDLES())))
    AS bundles;

+-------------+-----------------------+--------------------------------+
| BUNDLE_NAME | IS_ENABLED_BY_DEFAULT | IS_ACTUALLY_ENABLED_IN_ACCOUNT |
|-------------+-----------------------+--------------------------------|
| 2023_08     | True                  | True                           |
| 2024_01     | False                 | True                           |
+-------------+-----------------------+--------------------------------+