REPLICATION_DATABASES View (Information Schema): Changes to Column Values

Attention

This behavior change is in the 2023_01 bundle.

For the current status of the bundle, refer to Bundle History.

The following columns in the Information Schema REPLICATION_DATABASES view use the legacy account identifier format:

  • PRIMARY

  • REPLICATION_ALLOWED_TO_ACCOUNTS

  • FAILOVER_ALLOWED_TO_ACCOUNTS

  • ACCOUNT_NAME

The column values have changed as follows:

Previously:

For the following columns:

  • PRIMARY

  • REPLICATION_ALLOWED_TO_ACCOUNTS

  • FAILOVER_ALLOWED_TO_ACCOUNTS

The account identifier used the format:

<region_group>.<snowflake_ region>.<account_locator>

The ACCOUNT_NAME column displayed <account_locator>.

Currently:

For the following columns:

  • PRIMARY

  • REPLICATION_ALLOWED_TO_ACCOUNTS

  • FAILOVER_ALLOWED_TO_ACCOUNTS

The account identifier uses the format:

<organization_name>.<account_name>

The ACCOUNT_NAME column displays <account_name>.

Ref: 892