DATABASES and SCHEMATA views: New columns and rows to include personal databases and replication information (Preview)¶
Attention
This behavior change is in the 2025_02 bundle.
For the current status of the bundle, refer to Bundle History.
When personal databases are enabled and you query ACCOUNT_USAGE.DATABASES, ACCOUNT_USAGE.SCHEMATA, INFORMATION_SCHEMA.DATABASES, and INFORMATION_SCHEMA.SCHEMATA views, you will see new information in the OWNER and TYPE columns, as well as a new columns OWNER_ROLE_TYPE and REPLICABLE_WITH_FAILOVER_GROUPS.
In addition, REPLICABLE_WITH_FAILOVER_GROUPS will indicate whether a database is replicable as part of a failover group.
Column name |
New or existing |
Description |
|---|---|---|
OWNER |
Existing |
The owner for personal objects. |
OWNER_ROLE_TYPE |
Existing in ACCOUNT_USAGE and SCHEMATA views, new in INFORMATION_SCHEMA view |
The owner role of the personal object. |
TYPE |
Existing |
The type of personal object, such as PERSONAL DATABASE. |
REPLICABLE_WITH_FAILOVER_GROUPS |
New |
Whether the database is replicable as part of a failover group. Returns one of:
|
For more information on personal databases, see Private notebooks.
Ref: 1869, 1880