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.