REPLICATION_DATABASES View

This Information Schema view displays a row for each primary and secondary database (i.e. database for which replication has been enabled) in your organization.

Note

This view uses Snowflake terminology of “database”, whereas other Information Schema views use the standard INFORMATION_SCHEMA terminology of “catalog”. The two terms have the same meaning.

Columns

Column Name

Data Type

Description

REGION_GROUP

TEXT

Region group where the account that stores the database is located.

SNOWFLAKE_REGION

TEXT

Snowflake Region where the account that stores the database is located. A Snowflake Region is a distinct location within a cloud platform region that is isolated from other Snowflake Regions. A Snowflake Region can be either multi-tenant or single-tenant (for a Virtual Private Snowflake account).

ACCOUNT_NAME

TEXT

Name of the account in which the database is stored.

DATABASE_NAME

TEXT

Name of the database.

COMMENT

TEXT

Comment for the database.

CREATED

TIMESTAMP_LTZ

Date and time when the database was created.

IS_PRIMARY

TEXT

Whether the database is a primary database; otherwise, is a secondary database.

PRIMARY

TEXT

Name of the primary database.

REPLICATION_ALLOWED_TO_ACCOUNTS

TEXT

Where IS_PRIMARY is TRUE, shows the fully-qualified names of accounts where replication has been enabled for this primary database.

FAILOVER_ALLOWED_TO_ACCOUNTS

TEXT

Where IS_PRIMARY is TRUE, shows the fully-qualified names of accounts where failover has been enabled for this primary database.

Usage Notes

  • The view only displays objects for which the current role for the session has been granted access privileges. The view does not honor the MANAGE GRANTS privilege and consequently may show less information compared to a SHOW command when both are executed by a user who holds the MANAGE GRANTS privilege.