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.