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
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).
CREATED_ON	TIMESTAMP_LTZ	Date and time when the database was created.
ACCOUNT_NAME	TEXT	Name of the account in which the database is stored.
NAME	TEXT	Name of the database.
COMMENT	TEXT	Comment for the database.
IS_PRIMARY	TEXT	Whether the database is a primary database; otherwise, is a secondary database.
REGION_GROUP	TEXT	Virtual Private Snowflake customers only: Region group where the account that stores the database is located.

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.