Schema:

ACCOUNT_USAGE

DATABASES view

This Account Usage view displays a row for each database defined in your account.

Columns

Column NameData TypeDescription
DATABASE_IDNUMBERInternal/system-generated identifier for the database.
DATABASE_NAMEVARCHARName of the database.
DATABASE_OWNERVARCHARName of the role that owns the database.
IS_TRANSIENTVARCHARWhether the database is transient.
COMMENTVARCHARComment for the database.
CREATEDTIMESTAMP_LTZDate and time when the database was created.
LAST_ALTEREDTIMESTAMP_LTZDate and time the object was last altered by a DML, DDL, or background metadata operation. See Usage Notes.
DELETEDTIMESTAMP_LTZDate and time when the database was dropped.
RETENTION_TIMENUMBERNumber of days that historical data is retained for Time Travel.
RESOURCE_GROUPVARCHARFor internal use.
TYPEVARCHARSpecifies the type of database. Valid values are:

- APPLICATION: a Snowflake Native App.
- APPLICATION_PACKAGE: an application package.
- STANDARD: a normal database.
- IMPORTED DATABASE: a database created from a share.
- PERSONAL DATABASE: a personal database linked to its owner.
OWNER_ROLE_TYPEVARCHARThe type of role that owns the object, for example ROLE.
If a Snowflake Native App owns the object, the value is APPLICATION.
Snowflake returns NULL if you delete the object because a deleted object does not have an owner role.
OBJECT_VISIBILITYOBJECT

OBJECT_VISIBILITY

Snowflake logo in black (no text) Preview Feature — Open

Available to all accounts.

This property controls the discoverability of the objects in the account, enabling users without explicit access privileges to find objects and request access.

Usage notes

  • Latency for the view may be up to 180 minutes (3 hours).
  • The view displays all of the databases in an account.
  • The view does not recognize the MANAGE GRANTS privilege and consequently may show less information compared to a SHOW command executed by a user who holds the MANAGE GRANTS privilege.

  • The LAST_ALTERED column is updated when the following operations are performed on an object:

    • DDL operations.
    • DML operations (for tables only). This column is updated even when no rows are affected by the DML statement.
    • Background maintenance operations on metadata performed by Snowflake.