Schema:

ORGANIZATION_USAGE

DATABASES view

Important

This view is only available in the organization account. For more information, see Premium views in the organization account.

This Organization Usage view displays a row for each database defined in an account.

Columns

Organization-level columns

Column NameData TypeDescription
ORGANIZATION_NAMEVARCHARName of the organization.
ACCOUNT_LOCATORVARCHARSystem-generated identifier for the account.
ACCOUNT_NAMEVARCHARUser-defined identifier for the account.

Additional 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 24 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.