Schema:

ACCOUNT_USAGE

DATABASES View

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

Columns

Column Name

Data Type

Description

DATABASE_ID

NUMBER

Internal/system-generated identifier for the database.

DATABASE_NAME

TEXT

Name of the database.

DATABASE_OWNER

TEXT

Name of the role that owns the database.

IS_TRANSIENT

TEXT

Whether the database is transient.

COMMENT

TEXT

Comment for the database.

CREATED

TIMESTAMP_LTZ

Date and time when the database was created.

LAST_ALTERED

TIMESTAMP_LTZ

Date and time the object was last altered. See Usage Notes.

DELETED

TIMESTAMP_LTZ

Date and time when the database was dropped.

RETENTION_TIME

NUMBER

Number of days that historical data is retained for Time Travel.

RESOURCE_GROUP

VARCHAR

For internal use.

TYPE

VARCHAR

Specifies the type of database. Valid values are: . . - APPLICATION : an application object. . - APPLICATION_PACKAGE : an application package. . - STANDARD: a normal database. . - IMPORTED DATABASE: a database created from a share.

OWNER_ROLE_TYPE

TEXT

The type of role that owns the object, either ROLE or DATABASE_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.

Usage Notes

  • Latency for the view may be up to 180 minutes (3 hours).

  • The view displays all of the databases in the 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).

    • Background maintenance operations on metadata performed by Snowflake.