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 when the database was last altered.

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.

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 only displays objects for which the current role for the session has been granted access privileges.

  • 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.