This Account Usage view displays a row for each database defined in your account.
|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.|
- 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.